Re: Extracting query from application

From: Mladen Gogala <mgogala@xxxxxxxxxxx>
To: niall.litchfield@xxxxxxxxx
Date: Tue, 24 Oct 2006 21:53:32 -0400

On 10/24/2006 11:59:59 AM, Niall Litchfield wrote:
> If you are using a dedicated connection the easiest way to do this is to
> enable sql_trace for that session. You *will* find an appropriate method at
> http://www.petefinnigan.com/ramblings/how_to_set_trace.htm. shared
> connections present more of a challenge.
> 


Actually, they do not present a problem. The latest versions of Oracle have 
the tool called "trcsess" which can assemble the trace file for a single session
from several *s00*.trc files. You have to supply SID as an argument, but it will
do the trick on shared connections. This tool is not available in Oracle7.
-- 
Mladen Gogala
http://www.mladen-gogala.com

--
http://www.freelists.org/webpage/oracle-l

References:

Extracting query from application
From: J. Dex

Re: Extracting query from application
From: Niall Litchfield

Re: Extracting query from application

Other related posts: