grant execute on dbms_monitor to some_user
db username:
CREATE OR REPLACE TRIGGER trace_some_user
AFTER LOGON ON some_user.SCHEMA
BEGIN
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 = ''some_user''';
dbms_monitor.session_trace_enable (null,null,true,true);
END;
Os username:
CREATE OR REPLACE TRIGGER trace_some_user
AFTER LOGON ON database
declare
v_user varchar2(100);
begin
SELECT SYS_CONTEXT ('USERENV', 'OS_USER') into v_user from dual;
if v_user='some_user' 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 = ''some_user''';
dbms_monitor.session_trace_enable (null,null,true,true);
end if;
END;