You can also get an explanation of these event codes in the oraus.msg
file, which is NOT supplied on Windows installations, but can be found
in $ORACLE_HOME/rdbms/mesg on Unix
Rachel
- Rajesh.Rao_at_jpmchase.com wrote:
>
> 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).
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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 - 13:14:37 CDT
