Tracing Events - Anybody have a list of the Events?

From: <DBarbour_at_austin.isd.tenet.edu>
Date: Thu, 05 Jul 2001 08:21:43 -0700
Message-ID: <F001.00341B47.20010705081102@fatcity.com>

Morning Folks -

Hope those of you in the US had a safe and happy 4th - for those of you who didn't celebrate this particular holiday, hope your day was also safe and happy ( every day should be safe and happy!).

I'm trying to set up some tracing for various events/levels. Not using OEM. In the past (and currently), I've just used:

          event="10046 trace name context forever,level 4"

This of course provides the requisite information, but really can tell you much more than you want (or need) to know. The trace levels given on Metalink are:

                                                                                       
       
                                                               1 - Enable standard 
SQL_TRACE  
                                                               functionality (Default) 
       
                                                               4 - As Level 1 PLUS 
trace bind 
                                                               values                  
       
                                                               8 - As Level 1 PLUS 
trace      
                                                               waits                   
       
                                                                                       
       
                                                               However they state in 
multiple 
                                                               messages that:          
       
                                                                                       
       
                                                                                       
       
                                                                                       
       
                                                               "Events should be set 
only     
                                                               under the direction of 
Oracle  
                                                               Support and/or 
Development.    
                                                               Some events produce 
additional 
                                                               diagnostic information, 
others 
                                                               are intrusive into 
database    
                                                               operations, while 
others can   
                                                               effect data in the 
database.   
                                                               Syntax varies between 
events   
                                                               as does the meaning of 
the     
                                                               level. Oracle           
       
                                                               Support/Development 
will       
                                                               identify the proper 
syntax and 
                                                               level (if applicable) 
you      
                                                               should use."            
       
                                                                                       
       
                                                               In my handy copy of 
Steve      
                                                               Adam's Oracle 8i 
internals, he 
                                                               gives three different 
trace    
                                                               events (one of which is 
a      
                                                               level 13 - what the 
heck is    
                                                               that?), but they're all 
memory 
                                                               related.                
       
                                                                                       
       
                                                               Does anyone have a list 
of the 
                                                               events/levels they 
would care  
                                                               to share?               
       
                                                                                       
       
                                                               Regards,                
       
                                                                                       
       
                                                                                       
       

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: DBarbour_at_austin.isd.tenet.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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). Received on Thu Jul 05 2001 - 10:21:43 CDT