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

Thread: Alternative way to monitor dead process

  1. #1
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857

    Alternative way to monitor dead process

    Hello,

    I have this situation where in a developer or a DBO will approach me and will ask my assistance to monitor a certain process/session if it still working. Honestly my way eversince is by using the OEM, capture the screen for the intended session, make a note on the consumption of CPUs, Memory-PGA, I/O-Physical Reads, Logical Reads, and Hard Parses.
    and after awhile, I'll Refresh the OEM, and compare again the stats if there is still movement or no movement.

    Have you guys have a script to identify immediately if a certain process is dead? or the like.

    thanks a lot in advance.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    v$session.status
    v$sess_io
    v$session_wait

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Originally posted by pando
    v$session.status
    v$sess_io
    v$session_wait
    thanks pando,
    at least you lead my to dd views that I can start to dig in.

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