10g ,11g 都可以
SELECT d.value
||'/'
||lower(rtrim(i.instance, chr(0)))
||'_ora_'
||p.spid
||'.trc' trace_file_name
FROM
(SELECT p.spid
FROM v$mystat m,
v$session s,
v$process p
WHERE m.statistic# = 1
AND s.sid = m.sid
AND p.addr = s.paddr
) p,
(SELECT t.instance
FROM v$thread t,
v$parameter v
WHERE v.name = 'thread'
AND (v.value = 0
OR t.thread# = to_number(v.value))
) i,
( SELECT value FROM v$parameter WHERE name = 'user_dump_dest'
) d
11G
SELECT VALUE FROM V$DIAG_INFO where name='Default Trace File' ;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25099483/viewspace-774577/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25099483/viewspace-774577/