Tracing sessions

 

 

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 

 

Other related posts: