| 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?
All the events are there in $ORACLE_HOME/rdbms/mesg/oraus.msg
The ones you're interested in are the ones above 10000.
Regards,
Waleed
-----Original Message-----
[mailto:DBarbour_at_austin.isd.tenet.edu]
Sent: Thursday, July 05, 2001 12:11 PM
To: Multiple recipients of list ORACLE-L
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:
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).
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 - 10:41:47 CDT
 |
 |