RMS Batch - Trace session

PT  : RMS - Trace sessao (Logon Trigger) 

EN : RMS - Trace Session (Logon Trigger)

drop  trigger sys.set_trace_orrmsb;

create or replace trigger sys.set_trace_orrmsb
after logon on database
when (user in ('BATCH_USER'))
declare
retail_module varchar(200);
begin

select module into  retail_module from gv$session
where
sid =  upper(SYS_CONTEXT('USERENV','SID')) and ((upper(module) like '%ProC_Name%' ));

execute immediate 'alter session set statistics_level=ALL';
execute immediate 'alter session set max_dump_file_size=UNLIMITED';
execute immediate 'alter session set events ''10046 trace name context forever, level 12''';
execute immediate 'alter session set tracefile_identifier=''DBA_TRACE''';

exception
when no_data_found then
null;
when others then
null;

end;
/


drop  trigger sys.set_trace_orrmsb;