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

Thread: V$process

  1. #1
    Join Date
    Sep 2000
    Posts
    155
    I was wondering how to track the oracle process inside the database if you knwo the OS process ID using "top" or "ps -ef" command.

    We have one session eating up 60% of CPU resources and trying to track down it's path in the database and its activities inside the database.


    TIA

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    server_pid of....

    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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