Oracle-L: Re: ALTER SESSION SET EVENTS '...'

From: <Rajesh.Rao_at_jpmchase.com>
Date: Fri, 25 Oct 2002 09:14:17 -0800
Message-ID: <F001.004F3D6A.20021025091417@fatcity.com>

Mike,

These events are generally set at the advice of Oracle Support, or when the DBA needs to do some tracing. You might not find these in the docs, but Metalink should have notes on them.

Raj

                                                                                                                    
                    Michael                                                                                         
                    Ivanov               To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>        
                    <mivanov_at_tder        cc:                                                                        
                    a.ru>                Subject:     ALTER SESSION SET EVENTS '...'                                
                    Sent by:                                                                                        
                    root_at_fatcity.                                                                                   
                    com                                                                                             
                                                                                                                    
                                                                                                                    
                    October 25,                                                                                     
                    2002 12:44 PM                                                                                   
                    Please                                                                                          
                    respond to                                                                                      
                    ORACLE-L

I often met SQL phrase in sql scripts as "ALTER SESSION SET EVENTS '...' " for example:
ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT FOREVER, LEVEL 10';
(Oracle 8.1.7.3 patches install instuctions)
or
alter session set events '10046 trace name context forever, level <Level>';

where Level is one of 0,1,4,8,12 to trace your session

But I can't found some explanations for ALTER SESSION SET EVENTS '...' in Oracle documentation.
Who can me point some explanation to this command in Oracle docs ?

Best regards
Michael Ivanov, TD "ERA"

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Rajesh.Rao_at_jpmchase.com

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).

Received on Fri Oct 25 2002 - 12:14:17 CDT