Like the v$session_longops progress bar in OEM? You'll love this…
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.