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
v$parameter u_dump
cross join v$parameter db_name
cross join v$process
join v$session
on v$process.addr = v$session.paddr
where
u_dump.name = 'user_dump_dest' and
db_name.name = 'db_name' and
v$session.audsid=sys_context('userenv','sessionid');

11g以后的版本就可以直接 v$process join v$session后，读取v$process 里字段TRACEFILE 就可以了

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/67798/viewspace-1029004/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/67798/viewspace-1029004/