Re: Tracing or not tracing, this is the question now.

Okay Mladen, I'll bite.

How about checking the user_dump_dest?

David A. Barbour
AISD Confidentiality Notice: This email message, including all attachments, is for the sole use of the intended recipient(s) and may contain confidential student information. Unauthorized use or disclosure is prohibited under the federal Family Education Rights & Privacy Act (20 U.S.C. §1232g; 34 CFR Part 99). If you are not the intended recipient, you may not use, disclose, copy or disseminate this information. Please contact the sender by reply email or by contacting 414-0095 immediately and destroy all copies of the original message, including attachments.

                                                                                                                                       
                      "Gogala, Mladen"                                                                                                 
                      <MGogala_at_oxhp.com        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                   


                      >                        cc:                                                                                     

                      Sent by:                 Subject:  Tracing or not tracing, this is the question now.                             
                      root_at_fatcity.com                                                                                                 
                                                                                                                                       
                                                                                                                                       
                      01/15/2003 03:40                                                                                                 
                      PM                                                                                                               
                      Please respond to                                                                                                
                      ORACLE-L                                                                                                         
                                                                                                                                       
                                                                                                                                       

I'm looking for a way of checking which sessions on the database have trace turned on.
I can set event in another session, but I'd like to know whether the event (10046 in this case)
is set in some sessions.
Mladen Gogala
Oracle DBA
Oxford Health Plans
www.oxhp.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: DBarbour_at_austin.isd.tenet.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).