RE: Tracing sessions

Thanks Brandon,

   I did do a snapshot of the directory to see if there was any undo growth in the files over the course of time. However, nothing was showing activity. I'm wondering if I do have a rogue trace going on, will it kick in every time a session id and serial number match or should the trace have died when the session died?  

Oliver  

From: "Allen, Brandon" <Brandon.Allen_at_OneNeck.com>@DMR-CANADA Sent: Friday, October 27, 2006 2:20 PM
To: Oliver Jost; oracle-l
Subject: 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