Very cool, Thank You.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Scott Shafer
<sknd100@yaho To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
o.com> cc:
Sent by: Subject: Re: Tracing Events - Anybody
have a list of the Events?
root@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
[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [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).
- Tracing Events - Anybody have a list of the Events? DBarbour
- Re: Tracing Events - Anybody have a list of the Events? Scott Shafer
- RE: Tracing Events - Anybody have a list of the Events? Khedr, Waleed
- RE: Tracing Events - Anybody have a list of the Events? DBarbour
- RE: Tracing Events - Anybody have a list of the Events? Yosi
- RE: Tracing Events - Anybody have a list of the Events? Mohan, Ross
- RE: Tracing Events - Anybody have a list of the Events? Khedr, Waleed
- Re: Tracing Events - Anybody have a list of the Events? Scott Shafer
- RE: Tracing Events - Anybody have a list of the Events? Yosi
