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