Read the Trace file from SQL Plus

Find trace file in Oracle The following script returns the path to the trace file that the current session writes. It returns the path whether or not tracing is enabled. SQL> SELECT s.sid, 2 s.serial#, 3 pa.value || ‘\’ || LOWER(SYS_CONTEXT(‘userenv’,’instance_name’)) || 4 ‘_ora_’ || p.spid || ‘.trc’ AS trace_file 5 FROM v$session s, 6 v$process p, 7 v$parameter […]

Read More