RE: Tracing sessions

Yes, the traced session will continue to be traced after the session that initiated the trace has exited.  

One way to find out if a trace is currently being run is to check the most recent files in your user_dump_dest directory, but that's not a foolproof method since there could be a trace running, but no activity in the traced session, or there could be a trace being written to a directory other than your current user_dump_dest directory if someone changed the parameter temporarily or used other methods to write their trace file to a different location (e.g. I think you can do that with oradebug).  

Regards,
Brandon  

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Oliver Jost                   

        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.          

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l