RE: events number and meaning

[Deshpande, Kirti]

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 AM
To: Multiple recipients of list ORACLE-L
Subject: FW: events number and meaning

 

-----Original Message-----
From: Paulo Gomes
Sent: quarta-feira, 26 de Março de 2003 11:17
To: 
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