Re: events number and meaning
you can find the list of events under $ORACLE_HOME/rdbms/mesg/oraus.msg. babu - Original Message - From: Paulo Gomes To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 26, 2003 7:08 AM Subject: FW: events number and meaning -Original Message-From: Paulo Gomes Sent: quarta-feira, 26 de Março de 2003 11:17To:Subject: events number and meaning Hi guys. Where can i find a list of Oracle Db (8i, 9i and 9iR2) events and menning? and by the way how can i fire a Stored procedure if a event (ex.: Shutdown or Startup) is ocurring? Thanks PG
RE: events number and meaning
thanks regards PG -Original Message-From: Babu Nagarajan [mailto:[EMAIL PROTECTED]Sent: quarta-feira, 26 de Março de 2003 12:59To: Multiple recipients of list ORACLE-LSubject: Re: events number and meaning you can find the list of events under $ORACLE_HOME/rdbms/mesg/oraus.msg. babu - Original Message - From: Paulo Gomes To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 26, 2003 7:08 AM Subject: FW: events number and meaning -Original Message-From: Paulo Gomes Sent: quarta-feira, 26 de Março de 2003 11:17To:Subject: events number and meaning Hi guys. Where can i find a list of Oracle Db (8i, 9i and 9iR2) events and menning? and by the way how can i fire a Stored procedure if a event (ex.: Shutdown or Startup) is ocurring? Thanks PG
RE: events number and meaning
How do i see the info inside??? Regards PG -Original Message-From: Babu Nagarajan [mailto:[EMAIL PROTECTED]Sent: quarta-feira, 26 de Março de 2003 12:59To: Multiple recipients of list ORACLE-LSubject: Re: events number and meaning you can find the list of events under $ORACLE_HOME/rdbms/mesg/oraus.msg. babu - Original Message - From: Paulo Gomes To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 26, 2003 7:08 AM Subject: FW: events number and meaning -Original Message-From: Paulo Gomes Sent: quarta-feira, 26 de Março de 2003 11:17To:Subject: events number and meaning Hi guys. Where can i find a list of Oracle Db (8i, 9i and 9iR2) events and menning? and by the way how can i fire a Stored procedure if a event (ex.: Shutdown or Startup) is ocurring? Thanks PG
RE: events number and meaning
It used to be that all error messages between 1 and 10999 were events ... but I see some more in 21xxx, 23xxx range too in 9i. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message-From: Paulo Gomes [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 26, 2003 9:29 AMTo: Multiple recipients of list ORACLE-LSubject: RE: events number and meaning How do i see the info inside??? Regards PG -Original Message-From: Babu Nagarajan [mailto:[EMAIL PROTECTED]Sent: quarta-feira, 26 de Março de 2003 12:59To: Multiple recipients of list ORACLE-LSubject: Re: events number and meaning you can find the list of events under $ORACLE_HOME/rdbms/mesg/oraus.msg. babu - Original Message - From: Paulo Gomes To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 26, 2003 7:08 AM Subject: FW: events number and meaning -Original Message-From: Paulo Gomes Sent: quarta-feira, 26 de Março de 2003 11:17To:Subject: events number and meaning Hi guys. Where can i find a list of Oracle Db (8i, 9i and 9iR2) events and menning? and by the way how can i fire a Stored procedure if a event (ex.: Shutdown or Startup) is ocurring? Thanks PG This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: events number and meaning
1. Assuming Wait Events: Please check the Database Server Reference Guide for the respective release. Also check www.oraperf.com, there a list of wait events by Oracle Versions. Free membership is required. 2. Using triggers at database level. for example: create or replace trigger trig_mystoredproc after startup on database. declare begin -- your code, calls to other procs... etc end; / HTH, - Kirti -Original Message-From: Paulo Gomes [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 26, 2003 6:09 AMTo: Multiple recipients of list ORACLE-LSubject: FW: events number and meaning -Original Message-From: Paulo Gomes Sent: quarta-feira, 26 de Março de 2003 11:17To:Subject: events number and meaning Hi guys. Where can i find a list of Oracle Db (8i, 9i and 9iR2) events and menning? and by the way how can i fire a Stored procedure if a event (ex.: Shutdown or Startup) is ocurring? Thanks PG
RE: events number and meaning
Title: RE: events number and meaning -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] ... Also check www.oraperf.com, there a list of wait events by Oracle Versions. Free membership is required. I registered and logged in. When I click on wait events on the home page, I get the following: Warning: Sablotron error on line 2: XML parser error 2: syntax error in /opt/guide/www.oraperf.com/HTML/members/reference.html on line 32 Sorry, an error occurred. The reason is that XML parser error 2: syntax error and the error code is 2 Is Sablotron a new wait event? How long do I have to wait to see the list of events?
RE: events number and meaning
The link has been fixed. Thanks to Anjo for his quick response. Jared Jacques Kilchoer [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/26/2003 11:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: events number and meaning -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED] ... Also check www.oraperf.com, there a list of wait events by Oracle Versions. Free membership is required. I registered and logged in. When I click on wait events on the home page, I get the following: Warning: Sablotron error on line 2: XML parser error 2: syntax error in /opt/guide/www.oraperf.com/HTML/members/reference.html on line 32 Sorry, an error occurred. The reason is that XML parser error 2: syntax error and the error code is 2 Is Sablotron a new wait event? How long do I have to wait to see the list of events? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: events number and meaning
Title: RE: events number and meaning Works for me now. Thank you Mr. Kolk. ( http://www.oraperf.com - register, login, click on wait events) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] The link has been fixed. Jacques Kilchoer [EMAIL PROTECTED] I registered and logged in. When I click on wait events on the home page, I get the following: Warning: Sablotron error on line 2: XML parser error 2: syntax error in /opt/guide/www.oraperf.com/HTML/members/reference.html on line 32 Sorry, an error occurred. The reason is that XML parser error 2: syntax error and the error code is 2