oracle 数据库找到UDUMP的文件名称

oracle  数据库找到UDUMP的文件名称

select p.value||'\'||i.instance_name||'_ora_'||spid||'.trc' as "trace_file_name"
from v$parameter p ,v$process pro, v$session s,
 (select sid from v$mystat where rownum=1) m,
 v$instance i
where lower(p.name)='user_dump_dest'
and pro.addr=s.paddr
and m.sid=s.sid;

select p.value||'\'||i.instance_name||'_ora_'||spid||'.trc' as "trace_file_name"
from v$parameter p ,v$process pro, v$session s,
 (select sid from v$mystat where rownum=1) m,
 v$instance i
where lower(p.name)='user_dump_dest'
and pro.addr=s.paddr
and m.sid=s.sid;