Re: tracing someone else's session

Get the session id (SID) and serial number (SERIAL#) from v$session and then use the following command:

execute sys.dbms_system.set_sql_trace_in_session(<SID>,<SERIAL#>,TRUE);

Graham Thornton wrote:

> Having problems with an off-the-shelf software package that runs on top
> of Oracle - it's taking forever to do anything.
>
> From the software package itself there is no way to get to a SQL prompt,
> so I was wondering if it was possible to issue a 'alter session set
> sql_trace = TRUE' from another session (such as a DBA session).
>
> Anybody know if this can be done?
>
> Thanks
>
> Graham.
Received on Tue Sep 29 1998 - 23:05:50 CDT