-
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.
-
v$session.status
v$sess_io
v$session_wait
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|