Please create the below and disable or drop the trigger once completed.

 

create or replace trigger set_trace after logon on database

begin

if user not in (‘SYS’,’SYSTEM’,’SYSMAN’,’OLAPSYS’) then

execute immediate

‘Alter session set events ”10046 trace name context forever, level 12”’;

execute immediate

‘Alter session set timed_statistics=true’;

execute immediate

‘Alter session set statistics_level=typical’;

execute immediate

‘Alter session set tracefile_identifier=”TEST1_trace”’;

execute immediate ‘alter session set max_dump_file_size=unlimited’;

end if;

exception

when others then

null;

end;

/

Recommended Posts

Start typing and press Enter to search