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
[EMAIL PROTECTED] 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
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Shafer
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).
