Re: ALTER SESSION SET EVENTS '...'

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
>
> --- 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/

-- 
--
Mark J. Bobak
Oracle DBA
mark_at_bobak.net
"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: mark_at_bobak.net

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