Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: tracing someone else's session

Re: tracing someone else's session

From: Reiner Neumann <reiner.neumann_at_messe.de>
Date: Tue, 29 Sep 1998 16:12:08 +0200
Message-ID: <6uqpt7$hq0$1@mail.messe.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US