dba_enabled_traces
shows information about (standing) traces. Only traces that are enabled using one of the following methods will be reported: dbms_monitor.client_id_trace_enable
dbms_monitor.serv_mod_act_trace_enable
dbms_monitor.database_trace_enable
begin dbms_monitor.serv_mod_act_trace_enable( service_name => 'ORA19', module_name => dbms_monitor.all_modules, action_name => dbms_monitor.all_actions, binds => true, instance_name => null, plan_stat => null ); end; /
select * from dba_enabled_trace;
begin dbms_monitor.serv_mod_act_trace_disable ( service_name => 'ORA19' ); end; /