RE: Tracing Events - Anybody have a list of the Events?
Yeah, thanx all. It seems us poor NT users can't see the events list. We only rate an MSB file, not an MSG file. > -Original Message- > From: Scott Shafer [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 05, 2001 3:19 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Tracing Events - Anybody have a list of the Events? > > > Try oraus.msg (if it exists). Sorry I don't have an NT > install (woohoo! > ;-) to check on... > > Scott Shafer > San Antonio, TX > > > [EMAIL PROTECTED] wrote: > > > > Checking my oraus.msb file on NT, I don't see any list > > of events. Am I missing it or is it not there? I'm on > > 8.1.7 (didn't see it on 8.1.0 either). > > > > Thanks, > > > > yosi > > > > > -Original Message- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, July 05, 2001 2:07 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Re: Tracing Events - Anybody have a list of the Events? > > > > > > > > > > > > Very cool, Thank You. > > > > > > David A. Barbour > > > Oracle DBA, OCP > > > AISD > > > 512-414-1002 > > > > > > > > > > > > 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 > > _ > 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). > -- 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).
Re: Tracing Events - Anybody have a list of the Events?
Try oraus.msg (if it exists). Sorry I don't have an NT install (woohoo! ;-) to check on... Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: > > Checking my oraus.msb file on NT, I don't see any list > of events. Am I missing it or is it not there? I'm on > 8.1.7 (didn't see it on 8.1.0 either). > > Thanks, > > yosi > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, July 05, 2001 2:07 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: Tracing Events - Anybody have a list of the Events? > > > > > > > > Very cool, Thank You. > > > > David A. Barbour > > Oracle DBA, OCP > > AISD > > 512-414-1002 > > > > > > > > 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 _ 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).
RE: Tracing Events - Anybody have a list of the Events?
Only in UNIX -Original Message- Sent: Thursday, July 05, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 05, 2001 2:07 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Tracing Events - Anybody have a list of the Events? > > > > Very cool, Thank You. > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 > > > > > Scott Shafer > > recipients of list ORACLE-L <[EMAIL PROTECTED]> > o.com> cc: > > Sent by: Subject: Re: > Tracing Events - Anybody have a list of the Events? > root@fatcity. > > com > > > > > > 07/05/2001 > > 11:51 AM > > Please > > respond to > > ORACLE-L > > > > > > > > > > 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 > >
RE: Tracing Events - Anybody have a list of the Events?
msG -Original Message- Sent: Thursday, July 05, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 05, 2001 2:07 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Tracing Events - Anybody have a list of the Events? > > > > Very cool, Thank You. > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 > > > > > Scott Shafer > > recipients of list ORACLE-L <[EMAIL PROTECTED]> > o.com> cc: > > Sent by: Subject: Re: > Tracing Events - Anybody have a list of the Events? > root@fatcity. > > com > > > > > > 07/05/2001 > > 11:51 AM > > Please > > respond to > > ORACLE-L > > > > > > > > > > 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 > >
RE: Tracing Events - Anybody have a list of the Events?
Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 05, 2001 2:07 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Tracing Events - Anybody have a list of the Events? > > > > Very cool, Thank You. > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 > > > > > Scott Shafer > > recipients of list ORACLE-L <[EMAIL PROTECTED]> > o.com> cc: > > Sent by: Subject: Re: > Tracing Events - Anybody have a list of the Events? > root@fatcity. > > com > > > > > > 07/05/2001 > > 11:51 AM > > Please > > respond to > > ORACLE-L > > > > > > > > > > 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 > >
Re: Tracing Events - Anybody have a list of the Events?
Very cool, Thank You. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Scott Shafer o.com> cc: Sent by: Subject: Re: Tracing Events - Anybody have a list of the Events? root@fatcity. com 07/05/2001 11:51 AM Please respond to ORACLE-L 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 &g
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 1. 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
Re: Tracing Events - Anybody have a list of the Events?
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).
