cpu intensive process
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: cpu intensive process

  1. #1
    Join Date
    Oct 2007
    Posts
    114

    cpu intensive process

    Hi,

    I issue a TOP command in my Linux DB and I see this process which eats
    all the CPU (100%), How do I find this inside the database which program is being run?

    PID USER PR NI %CPU TIME+ %MEM VIRT RES SHR S COMMAND
    9763 oracle 25 0 100 7:35.75 3.6 1121m 146m 142m R oracle


    Thanks

  2. #2
    Join Date
    Jun 2007
    Location
    Milwaukee,WI
    Posts
    27
    join v$session,v$process,v$sqlarea. yo'll get what you want.

    Akash
    OCP 8i


  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Or simply use awr report.

  4. #4
    Join Date
    Oct 2007
    Posts
    114
    where do I get the awk report?

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    awr not awk, its a 10g report - seeing as though you dont say what version you are on you get limited help

  6. #6
    Join Date
    Oct 2007
    Posts
    114
    is this similar to statspack?

  7. #7
    Join Date
    Jun 2007
    Location
    Milwaukee,WI
    Posts
    27
    oh yeah it's kind of upgraded statspack report.

    Akash
    OCP 8i


  8. #8
    Join Date
    Jul 2008
    Posts
    1

    Smile Mahendra -DBA

    use this command

    v$session,v$process in which you use sid,addr,pid,saddr,osuser,status

    if status is inactive then kill this process pid. by this

    OS level

    $kill -9 pid

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote Originally Posted by mahendra_mmm
    use this command

    v$session,v$process in which you use sid,addr,pid,saddr,osuser,status

    if status is inactive then kill this process pid. by this

    OS level

    $kill -9 pid
    so just kill it without working out what it is doing - interesting

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