Add new comment
Like the v$session_longops progress bar in OEM? You'll love this…
Submitted by dave on Wed, 12/13/2006 - 16:31
One of the redeeming qualities of the Java Oracle Enterprise Manager client is the progress bar that comes up when you are viewing the long operations of a session. I wanted this functionality but didn’t want to wake up the big lug to get this info (it takes a long time to start up the OEM client and navigate to the screen to see the long operations progress bar).
So I decided to write a short script to emulate that functionality but take it one step further and show me info about _all_ the longops currently running on an instance.
Perl source code is available here.
If you need instructions on installing Perl, DBI, and DBD::Oracle on a PC, instructions are here.
– Dave
Tags: