Trace you own session using dbms_system / set events

For debugging … Make sure the session has a direct execute grant on dbms_system package.

Level 12 makes sure to include the waits and bind data. dbms_system

begin
for i in (select sid, serial# from v$session where audsid=SYS_CONTEXT('USERENV','SESSIONID'))
loop
	sys.dbms_system.set_ev ( si => i.sid, se => i.serial#, ev => 10046, LE => 12, nm => '');
end loop;
end;
/
ALTER SESSION SET EVENTS '10046 trace name context forever, level 12';

Leave a Reply

Helpful? - leave your note below so I can brag

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>