Shows Trace Filename for Current Session
--
-- Shows the Trace File Name for the Current Session.
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
COLUMN value FORMAT A100
 
SELECT value
FROM   v$diag_info
WHERE  name = 'Default Trace File'
/

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License