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