| 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: Trace/Event Info
If you have access to Oracle on a unix system, take a look at $ORACLE_HOME/rdbms/admin/oraus.msg.
Events 10000 - 10999 are of interest here. You may also note that it says they are for debugging Oracle. As such you will likely never find documentation for some of them.
A few of them are documented in the file.
Jared
Walter K <alden14004_at_YAHOO.COM>
Sent by: root_at_fatcity.com
01/23/02 06:50 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: Trace/Event Info
Howdy!
Is a document available somewhere that explains the different trace levels and also the commonly used events for tracing? For instance, I know to use event 10046 with level 4 to get the bind variable values in a trace, but why this particular combination of event and trace level? What are the different levels and how are they used? How are process state and system state dumps performed? I'm also interested in some info that explains how to interpret the various trace files that are produced, other than just looking for SQL in them. Etc...
Thanks again!
-w
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Jared.Still_at_radisys.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 Wed Jan 23 2002 - 14:42:06 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |