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:[EMAIL PROTECTED]]
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: [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: Khedr, Waleed
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).
