Script to create trace at database schema level by enabling trigger model.

Please execute the below and change the username accordingly. After the trace drop the trigger.

CREATE OR REPLACE TRIGGER “1234_TMP_LOGGINGTRIG”
AFTER LOGON ON DATABASE
begin
if ora_login_user = ‘1234’ 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=”1234_trace”’;
end if;
end;
/