after logon session trace

Чет, надоело каждый раз искать код after logon trigger'a для трассировки сессии, вот решил в блог его запостить.

CREATE OR REPLACE TRIGGER after_logon_trg
AFTER logon ON DATABASE
declare
  mo varchar2(100);
  ma varchar2(100);
BEGIN
  SELECT module, machine into mo,ma
  FROM v$session
  WHERE audsid = USERENV ('sessionid') AND ROWNUM <= 1;

  IF (mo='JDBC Thin Client' and USER='SHIRYAEV') THEN
     EXECUTE IMMEDIATE 'ALTER SESSION SET max_dump_file_size=unlimited';
     EXECUTE IMMEDIATE 'ALTER SESSION SET tracefile_identifier=''id''';
     EXECUTE IMMEDIATE 'ALTER SESSION SET EVENTS ''10046 trace name context forever, level 12''';
  end if;
END;