Trace

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;