Trigger to log the database shutdown

  
SQL>
SQL> CREATE TABLE uptime_log (
  2      database_name       VARCHAR2(30),
  3      event_name          VARCHAR2(20),
  4      event_time          DATE,
  5      triggered_by_user   VARCHAR2(30)
  6      );

Table created.

SQL>
SQL> CREATE OR REPLACE TRIGGER log_shutdown
  2  BEFORE SHUTDOWN ON DATABASE
  3  BEGIN
  4      INSERT INTO uptime_log
  5          (database_name,
  6           event_name,
  7           event_time,
  8           triggered_by_user)
  9          VALUES (sys.database_name,
 10                  sys.sysevent,
 11                  sysdate,
 12                  sys.login_user);
 13      COMMIT;
 14  END;
 15  /

Trigger created.

SQL>
SQL> drop table uptime_log;

Table dropped.

SQL>
SQL> --

Related examples in the same category

1.	Trigger for database startup event
2.	Logon trigger
3.	After logon database trigger
4.	Log database logon to a table
5.	Log a server error to a table
6.	Log a server error with information on time, user name, database name
7.	A system trigger(AFTER CREATE ON DATABASE) .
8.	creating a logon/logoff auditing system using system-level triggers:
9.	Save information about all errors in an after-servererror on database
10.	Submit a job for altering user in an after-create-database trigger

Trigger to log the database shutdown : Database Trigger « Trigger « Oracle PL / SQL

Related examples in the same category