This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
My question is not directly related with LightSpeed, but i guess you may help me. There is useful tool in SQL Server called SQL Profiler, but i cannot find similar tool for oracle. My task is to determine moment of time when lightspeed performs connection to database, creates session, sets transaction isolation level, makes SQL queries. SQL Server Profiler solves all these tasks. How do you debug lightspeed to oracle?
|
|
|
We're not familiar with the Oracle tool chain to this level of detail, so I think you'd be better off asking on an Oracle forum. Googling for "oracle profiler" threw up http://stackoverflow.com/questions/148648/oracle-is-there-a-tool-to-trace-queries-like-profiler-for-sql-server which indicates that Oracle Enterprise Manager may do what you need. There also appears to be something called dbms_profiler, and http://www.orafaq.com/forum/t/39569/0/ mentions a couple of tracing utilities. But you'll get better advice from a specialist Oracle forum -- let us know what you find out! |
|
|
@mpp, not sure will it be sufficient for you, but maybe you can try the free SQL Monitor tool from Quest Software (maybe you know Toad - their most famous product, great tool for Oracle administration). You can find SQL Monitor here: It should give you some feedback with timestamps on transactions, queries etc. which are performed on your Oracle database by selected processes.
|
|
|
Forgot to mention. Do try the link at www.toadworld.com above. The one at www.toadsoft.com is an old version (but Google seems to care only about that old version). BTW, looking closer at your question, SQL Monitor should give you also an indication when a connection has been made.. Give it a spin, if you're still looking. |
|