RE: list of events

From: <Rachel_Carmichael_at_Sonymusic.com>
Date: Wed, 15 May 2002 05:48:24 -0800
Message-ID: <F001.00460FDD.20020515054824@fatcity.com>

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|

|        |          i_at_espn.com       |

|        |                           |

|        |          05/14/2002 05:43 |

|        |          PM               |

|        |          Please respond to|

|        |          ORACLE-L         |

|        |                           |

|--------+--------------------------->
  >----------------------------------------------------|
  |                                                    |
  |       To:     ORACLE-L_at_fatcity.com                 |
  |       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:Rachel_Carmichael_at_Sonymusic.com] 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)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Rachel_Carmichael_at_Sonymusic.com

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



application/octet-stream attachment: Text - character set unknown

Received on Wed May 15 2002 - 08:48:24 CDT