Tracing SQL

[synapsevampire]

Using Oracle 8.

I would like to be able to capture the SQL being passed from an application, and wonder what the best means to do so is using Oracle?

In SQL Server we just turn on the Trace from the Query Analyzer.

The intent of this is to use the same joins when extracting similar information in out reporting efforts.

Appreciate any feedback.

-k

 

[ddiamond]

You can do it with Oracle Top-Sessions. It will allow you to veiw any sql that is currently being processed by the oracle engine. It won't keep a running log, however, so you would have to catch the sql while the app is running.

 

[synapsevampire]

Isn't that Oracle 10 only?

-k

 

[ddiamond]

No, I am using it with oracle 8.0.5.0. It came with oracle.

 

[synapsevampire]

Great, thanks, let me try to locate and test it.

-k

 

[ddiamond]

This is part of the oracle diagnostic pack. I believe it is a seperate cd. There also is a utility in there called trace, but I have never used it.