获取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
m
y
s
t
a
t
m
,
s
y
s
.
v
mystat m, sys.v
mystatm,sys.vsession 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 p r o c e s s w h e r e a d d r = ( s e l e c t p a d d r f r o m v process where addr=(select paddr from v processwhereaddr=(selectpaddrfromvsession where sid=(select distinct sid from v$mystat));