$ sqlplus "/ as sysdba"sql*plus: release 9.2.0.4.0 - production on fri oct 8 12:08:09 2004copyright (c) 1982, 2002, oracle corporation. all rights reserved.connected to:oracle9i enterprise edition release 9.2.0.4.0 - 64bit productionwith the partitioning, olap and oracle data mining optionsjserver release 9.2.0.4.0 - productionsql> set echo onsql> @gettrcnameunixsql> select d.value 2 || '/' 3 || lower (rtrim (i.instance, chr (0))) 4 || '_ora_' 5 || p.spid 6 || '.trc' trace_file_name 7 from (select p.spid 8 from v$mystat m, v$session s, v$process p 9 where m.statistic# = 1 and s.sid = m.sid and p.addr = s.paddr) p, 10 (select t.instance 11 from v$thread t, v$parameter v 12 where v.name = 'thread' 13 and (v.value = 0 or t.thread# = to_number (v.value))) i, 14 (select value 15 from v$parameter 16 where name = 'user_dump_dest') d 17 /trace_file_name--------------------------------------------------------------------------------/opt/oracle/admin/hsbill/udump/hsbill_ora_29630.trc
for nt:
sql> select d.value 2 || '/' 3 || lower (rtrim (i.instance, chr (0))) 4 || '_ora_' 5 || p.spid 6 || '.trc' trace_file_name 7 from (select p.spid 8 from v$mystat m, v$session s, v$process p 9 where m.statistic# = 1 and s.sid = m.sid and p.addr = s.paddr) p, 10 (select t.instance 11 from v$thread t, v$parameter v 12 where v.name = 'thread' 13 and (v.value = 0 or t.thread# = to_number (v.value))) i, 14 (select value 15 from v$parameter 16 where name = 'user_dump_dest') d 17 /trace_file_name--------------------------------------------------------------------------------e:/oracle/admin/eygle/udump/eygle_ora_3084.trc
