Re: tracing someone else's session

From: Avion Consulting & Services <a_at_b.com>
Date: Wed, 30 Sep 1998 01:12:07 +1000
Message-ID: <361107d0.0@pink.one.net.au>

You have to be running 7.3+ version of the databse to do this : exec sys.dbms_system.set_sql_trace_in_session( sid, serial#, true )

Sridhar Subramaniam

Graham Thornton wrote in message <3610DFFC.640F_at_ln.ssw.abbott.com.nospam>...
>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 - 10:12:07 CDT