Search notes:
Oracle: DBA_ENABLED_TRACES
dba_enabled_traces shows information about
(standing) traces. Only traces that are enabled using one of the following methods will be reported:
This
view comes in the two variants
dba_enabled_traces and
cdb_enabled_traces.
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;
/