开启ora会话级别trace

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);

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;