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

Home -> Community -> Mailing Lists -> Oracle-L -> Tracing sessions

Tracing sessions

From: Oliver Jost <Oliver.Jost_at_ca.fujitsu.com>
Date: Fri, 27 Oct 2006 17:05:43 -0400
Message-ID: <DB508580748FAD4692628A58C4E653F52135A2@MAIL01.Corp.FC.LOCAL>

   

Hi All,

    I just have a question about tracing a session. Using sys.dbms_system.set_ev(&sid, &serial, 10046, 12, '')

Hypothetically speaking:

If we start a trace with sys.dbms_system.set_ev(&sid, &serial, 10046, 12, '')  

And we never execute sys.dbms_system.set_ev(&sid, &serial, 10046, 0, '')  

We exit the current session which issued the trace.  

Will the trace still be on for the submitted sid and serialnum?  

I am curious to find out how to identify if a trace is currently being run.    

Thank you,

     Oliver  

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 27 2006 - 16:05:43 CDT

Original text of this message

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