📋Steps in this guide1/1

Enable trace for a session

EXEC DBMS_SYSTEM.set_sql_trace_in_session(sid=>321, serial#=>1234, sql_trace=>FALSE);

oracle configurationintermediate

by OracleDba

12 views

Enable trace for a session

Get the trace file name

Code/Command (click line numbers to comment):

1
2

EXEC DBMS_SYSTEM.set_sql_trace_in_session(sid=>321, serial#=>1234, sql_trace=>FALSE);
SELECT p.tracefile FROM v$session s JOIN v$process p ON s.paddr = p.addr WHERE s.sid = 321;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!