Wednesday, March 14, 2007

Udump trace file name & location

SELECT p1.value'/'p2.value'_ora_'p.spid'.trc' filename
FROM
v$process p,
v$session s,
v$parameter p1,
v$parameter p2
WHERE p1.name = 'user_dump_dest'
AND p2.name = 'db_name'
AND p.addr = s.paddr
AND s.audsid = USERENV ('SESSIONID');

No comments: