www.oracle-wiki.net SQL Library
-- -- 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' /