Event 10928 controls if tracing of all executed PL/SQL pseudo codes is enabled.
Create a simple demonstration function:
-- drop function tq84_f;
create function tq84_f(n integer) return number authid definer as
begin
if n > 5 then
return 2 * n;
end if;
return 3 * n;
end tq84_f;
/
-- alter function tq84_f compile debug;
Enable tracing
alter session set events '10928 trace name context level 1';
-- alter session set events '10938 trace name context level 5';
select
trc.payload,
trc.timestamp
from
v$diag_info inf join
v$diag_trace_file_contents trc on regexp_replace(inf.value, '.*[\\/]', '') = trc.trace_filename
where
inf.name = 'Default Trace File'
order by
trc.line_number
;