RPM 13.1.x - Trace session

EN

Por vezes e necessario fazer trace a sessao desde inicio, nessas situacoes e util usar um  logon trigger
ex: baches de rpm

PT
Sometimes is useful to trace the session from the beginning, for that is useful to use a logon trigger
eg RPM batches

Code

SQL>
 SQL> drop trigger sys.set_trace_rpm;

SQL> create or replace trigger sys.set_trace_rpm

after logon on database

when (user in ('RPM_OAS'))

declare

retail_module varchar(200);

begin

select module into  retail_module from gv$session

where

sid =  upper(sys_context('userenv','sid'))

and (osuser is null and machine like 'rpm_app_server%');

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=''RA_RPM''';

exception

when no_data_found then

    null;

when others then

    null;

end;

/

Trigger created.

SQL>  drop trigger sys.set_trace_rpm;
Trigger dropped.

Code

SQL> create or replace trigger sys.set_trace_rpm
after logon on database
when (user in ('RPM_WEBLOGIC'))
declare
  retail_module varchar(200);
begin

 select module into  retail_module from gv$session
 where sid =  upper(sys_context('userenv','sid')) and  SERVICE_NAME like 'RPM14_SERVICE';

 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=''RPM''';
  
 exception
 when no_data_found then
    null;
 when others then
    null;

end;
/

Trigger created.

SQL> select OWNER,TRIGGER_NAME,STATUS from dba_triggers  where trigger_name like upper('set_trace_rpm');

OWNER                          TRIGGER_NAME                   STATUS
------------------------------ ------------------------------ --------
SYS                            SET_TRACE_RPM                  ENABLED


SQL> drop trigger sys.set_trace_rpm;

Trigger dropped.

Obrigado pela leitura, espero que este post o tenha ajudado :)
Thank you for reading, hope this post was helpful  :)