True enough, but the level of detail describing most events is distressingly minimal. Unless you already know what the event does, setting it is probably a REALLY bad idea.
Of course, what I like to do is create a small throwaway database. Then I can set events to my heart's content, just to see what happens. If I kill the database, I just trash it and start over. Having a throwaway database to play in is essential for such experimentation. ;-) -Mark On Fri, 2002-10-25 at 14:14, Rachel Carmichael wrote: > 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 > > --- [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> > > <mivanov@tder cc: > > > > a.ru> Subject: ALTER SESSION > > SET EVENTS '...' > > Sent by: > > > > root@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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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/ -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] "It is not enough to have a good mind. The main thing is to use it well." -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).