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

Thread: user trace files

  1. #1
    Join Date
    May 2001
    Posts
    285

    Question

    If more than one users have enabled tracing, how can we tell which trace file is belong to which user?

    The trace file is name as ORAXXXX.trc and they are located in the folder specified by the init.ora parameter USER_DUMP_DEST, while XXXX is supposed to the OS Process Identifier.

    So the question is also:
    How can we know which OS process identifier is associated with certain user?

    Thanks a lot!

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Code:
    set pages 50
    col kill_by for a12
    col username for a12
    col program for a40 
    col "MACHINE/PID" for a20
    set linesize 132
    set pages 100
    select '''' || s.sid ||','||s.serial# || '''' kill_by, 
       p.spid server_pid, s.username, s.program, 
       decode(s.process, NULL, s.machine, s.machine || ' PID: ' ||  s.process) "MACHINE/PID" ,
       s.server, s.status
    from v$session s, v$process p
    where s.username is not null
    and s.paddr = p.addr
    order by to_number(p.spid)
    /
    Jeff Hunter

  3. #3
    Join Date
    May 2001
    Posts
    285
    Works great!

    Thanks again, Jeff!

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