RE: Tracing Events - Anybody have a list of the Events?

msG

-----Original Message-----
Sent: Thursday, July 05, 2001 2:36 PM
To: Multiple recipients of list ORACLE-L

Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either).

Thanks,

yosi

> -----Original Message-----
> From: DBarbour_at_austin.isd.tenet.edu
> [mailto:DBarbour_at_austin.isd.tenet.edu]
> Sent: Thursday, July 05, 2001 2:07 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Tracing Events - Anybody have a list of the Events?
>
>
>
> Very cool, Thank You.
>
> David A. Barbour
> Oracle DBA, OCP
> AISD
> 512-414-1002
>
>
>
>
> Scott Shafer
>
> <sknd100_at_yaho To: Multiple
> recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> o.com> cc:
>
> Sent by: Subject: Re:
> Tracing Events - Anybody have a list of the Events?
> root_at_fatcity.
>
> com
>
>
>
>
>
> 07/05/2001
>
> 11:51 AM
>
> Please
>
> respond to
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
> Look near the end (~70% through) of the
> $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events.
> This is about all I could find. Anyone else?
>
> Scott Shafer
> San Antonio, TX
>
>
> DBarbour_at_austin.isd.tenet.edu wrote:
> >
> > 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
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Scott Shafer
> INET: sknd100_at_yahoo.com
>
> 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).
>
>
>
>
> --
> 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).
>

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

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: MohanR_at_STARS-SMI.com

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