[Oracle] Trigger

특정 계정 로그인 발생시 Trace 수행하는 트리거.

 

CREATE OR REPLACE TRIGGER ORAKIM.SET_TRACE 
AFTER LOGON ON DATABASE
WHEN (ORA_LOGIN_USER LIKE 'ORAKIM')
BEGIN 
  EXECUTE IMMEDIATE 'alter session set tracefile_identifier = '||'LOGMNR'; 
  EXECUTE IMMEDIATE 'alter session set statistics_level=ALL'; 
  EXECUTE IMMEDIATE 'alter session set max_dump_file_size=UNLIMITED'; 
  EXECUTE IMMEDIATE 'alter session set events ''10046 trace name context forever, level 12'''; 
END SET_TRACE
;