Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tracing someone else's session
As DBA:
At first select The SID And SERIAL# from V$session,
then :
execute dbms_system.set_sql_trace_in_session(SID,SERIAL#,True);
This works only on newer Oracle-Versions.(from 7.2 on)
So long, Reiner
Graham Thornton schrieb in Nachricht
<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 - 09:12:08 CDT