You can use the oerr facility on Unix to look at the events... I don't know if that file exists under Windows, I vaguely recall a conversation on the list a while ago where people were saying it didn't. I know that I downloaded the file from my Unix box to my PC so I'd have a copy. Anyone out there with a Windows installation who can check this please? And, in any case, the file just tells you what the event name is: bash$ oerr ora 10053 10053, 00000, "CBO Enable optimizer trace" // *Cause: // *Action: bash$ oerr ora 10046 10046, 00000, "enable SQL statement timing" // *Cause: // *Action: and doesn't give you much other information. I'd love to see an Oracle doc just on these events.... Rachel |--------+---------------------------> | | | | | | | | Rajendra.Jamadagn| | | [EMAIL PROTECTED] | | | | | | 05/14/2002 05:43 | | | PM | | | Please respond to| | | ORACLE-L | | | | |--------+---------------------------> >----------------------------------------------------| | | | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: RE: list of events | >----------------------------------------------------| Rachel, Actually, error messages between 10000 and 10999 are events (i.e. 10046, 10053 etc). In 9i there are some new events in the 297xx range as well. Raj ______________________________________________________ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -----Original Message----- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 4:53 PM To: Multiple recipients of list ORACLE-L actually that's the list of error messages, not events and it's not under the admin directory in any case the path to the error messages is: $ORACLE_HOME/rdbms/mesg/roaus.msg (See attached file: ESPN_Disclaimer.txt)
ESPN_Disclaimer.txt
Description: Text - character set unknown