获取oracle trace文件路径

获取oracle trace文件路径

10g:
/* 11g依然有效 */

SELECT d.VALUE
|| ‘/’
|| LOWER (RTRIM (i.instance, CHR (0)))
|| ‘ora’
|| p.spid
|| ‘.trc’
trace_file_name
FROM (SELECT p.spid
FROM sys.v$mystatm,sys.v$session s, sys.vKaTeX parse error: Expected 'EOF', got '#' at position 38: …ERE m.statistic#̲ = 1 AND s.sid …thread t, sys.vKaTeX parse error: Expected 'EOF', got '#' at position 95: …= 0 OR t.thread#̲ = TO_NUMBER (v…parameter
WHERE name = ‘user_dump_dest’) d;
11g:

select value from v$diag_info where name=‘Default Trace File’;

select tracefile from v$processwhereaddr=(selectpaddrfromv$session where sid=(select distinct sid from v$mystat));