Re: How to trace other session?

If the session already exists, go to v$session and get the sid and the serial# of the session you are interested in. .
Then, using sqlplus, as "sys" unless you granted additional authority,

       execute dbms_system.set_sql_trace_in_session(sid, ser, TRUE);

when finished

       execute dbms_system.set_sql_trace_in_session(sid, ser, FALSE);

Then run tkprof on the resulting ".trc" file.

Tim

Doug Cowles wrote:

> How can I turn on trace for someone else's already
> running session? I'm pretty sure there is a way to do
> this..
>
> - Dc.
Received on Tue Jul 13 1999 - 11:46:52 CDT