Search notes:

Oracle: DBMS_MONITOR

Procedures

client_id_stat_enable, client_id_stat_disable
client_id_trace_enable, client_id_trace_disable
database_trace_enable, database_trace_disable Enables/disables the SQL Trace facility on database level. Compare with dbms_session.set_sql_trace.
serv_mod_act_stat_enable, serv_mod_act_stat_disable
serv_mod_act_trace_enable, serv_mod_act_trace_disable
session_trace_enable, session_trace_disable
declare
   client_id  varchar2(20) := 'tq84';
begin

   dbms_session.set_identifier(client_id);
   dbms_monitor.client_id_trace_enable(client_id => client_id);

end;
/

See also

dba_enabled_traces / cdb_enabled_traces
Tracing SQL statement execution
Oracle DBMS PL/SQL packages

Index