Re: Extracting query from application

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Tue, 24 Oct 2006 21:53:32 -0400
Message-id: <1161741212l.3591l.2l@medo.noip.com>

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

Received on Tue Oct 24 2006 - 20:53:32 CDT