DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to find your own trace file from udump directory?

  1. #1
    Join Date
    Feb 2001
    Location
    Atlanta, USA
    Posts
    131
    Hi

    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...



    Anandharaj
    a_anandharaj@yahoo.com

  2. #2
    Join Date
    Apr 2002
    Posts
    9

    Smile

    Hi,

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width