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

Thread: find out which user has this OS pid...

  1. #1
    Join Date
    Aug 2000
    Posts
    12

    find out which user has this OS pid...

    All, how can I find out which user has this OS PID in oracle and where is he loggind in from.
    oracle 2858 1 0 Nov 28 ? 0:00 oracleprod (LOCAL=NO)
    this proc has been running to long.

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    select S.* from gv$session S, gv$process P
    where spid=2858
    and S.paddr=P.addr
    ;
    Ales
    The whole difference between a little boy and an adult man is the price of toys

  3. #3
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349

    Arrow

    execute this sql, IN spid give your OS pid number

    select a.serial#,a.osuser,a.program,a.machine,c.sql_text from v$session a, v$process b,v$sqlarea c
    where a.paddr=b.addr
    and b.spid=&spid
    and a.sql_hash_value=c.hash_value
    /
    http://www.perf-engg.com
    A performance engineering forum

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