making a logon trigger for session tracing in oracle

CREATE OR REPLACE TRIGGER
enable_10046_trace_trigger after logon on database
begin
if user ='AHSAN_DEV' then
execute immediate 'alter session set timed_statistics = true';
execute immediate 'alter session set max_dump_file_size = unlimited';
execute immediate 'alter session set tracefile_identifier = ''AHSAN''';
execute immediate 'alter session set events ''10046 trace name context forever, level 12'' ';
end if;
end;/

Sphere: Related Content