Find UDUMP file through SQL

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;