CREATE OR REPLACE TRIGGER “123456_TMP_LOGONTRIG”
AFTER LOGON ON DATABASE
begin
if ora_login_user = ‘123456’ 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=”123456_trace”’;
end if;
end;
/
Share this post
Recent Posts

Leave a Comment

Start typing and press Enter to search