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