EXECUTE dbms_monitor.session_trace_enable (
, , waits=>true, binds=>true);
--->Check the trace file that would be created :
SELECT s.sid,p.tracefile
FROM v$session s
JOIN v$process p ON s.paddr = p.addr
WHERE s.sid in ();
---> Let it run for sometime
--->and then disable the trace:
EXECUTE dbms_monitor.session_trace_disable (session_id => , serial_num => );
No comments:
Post a Comment