| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
-- 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).Received on Thu Jul 05 2001 - 11:51:58 CDT
 |
 |