开启ora会话级别trace

通过DBMS_MONITOR.session_trace_enable开启会话跟踪 - 文章详情 (itpub.net)

EXEC DBMS_MONITOR.session_trace_enable(session_id =>5350, serial_num=>1620, waits=>TRUE, binds=>true);

EXEC DBMS_MONITOR.session_trace_disable(session_id=>5350, serial_num=>1620);

都是sys会话下执行

select a.sid,a.serial#,b.spid,b.tracefile from v$session a,v$process b where a.paddr=b.addr and a.sid=&sid;