How will you find your own trace file from the udump directory, if multiple users generated the trace file at the same time (with in micro seconds)... ? i mean how will you identify your trace file.... (WinNT / UNIX)
Could some one throw some light on this...
select c.value || '/' || 'ora_' ||
ltrim(to_char(a.spid,'fm99999')) || '.trc'
from v$process a, v$session b, v$parameter c, v$thread c
where a.addr = b.paddr
and b.audsid = userenv('sessionid')
and c.name = 'user_dump_dest'
gives trace filename for current session.
Click Here to Expand Forum to Full Width