oracle安装文件看版本号,10g以下版本ORACLE查TRACE 文件

select

u_dump.value || '/' ||

db_name.value || '_ora_' ||

v$process.spid ||

nvl2(v$process.traceid, '_' || v$process.traceid, null )

|| '.trc' "Trace File"

from

u_dump

cross join db_name

cross join

join

on v$process.addr = v$session.paddr

where

u_dump.name = 'user_dump_dest' and

db_name.name = 'db_name' and

v$session.audsid=('userenv','sessionid');

11g以后的版本就可以直接 join 后，读取 里字段TRACEFILE 就可以了[@more@]