SQL> COL trace_file FOR A75 SQL> col VALUE format a50 SQL> col name format a20 SQL> select name,value 2  from v$parameter 3  where name=’user_dump_dest’; NAME                 VALUE ——————– ————————————————– user_dump_dest       D:\ORACLE\PRODUCT\10.2.0\ADMIN\SRIRAM_TEST\UDUMP SQL> SELECT s.sid,             s.serial#,         … Continue reading Get the trace file name and read it