• Welcome
• Projects
• Presentations
• Research

System Triggers

System triggers were introduced in Oracle 8.1.5

Trace can be enabled / disabled using system triggers e.g.

CREATE OR REPLACE TRIGGER us01_logon
AFTER LOGON ON us01.SCHEMA 
BEGIN
  dbms_session.set_sql_trace (TRUE);
END;

CREATE OR REPLACE TRIGGER us01_logoff 
BEFORE LOGOFF ON us01.SCHEMA
BEGIN
  dbms_session.set_sql_trace (FALSE);
END;

Once the system trigger has been created it can be enabled and disabled using:

ALTER TRIGGER us01_logon ENABLE;
ALTER TRIGGER us01_logon DISABLE;