ba6.us - Dave's Database Related Stuff

Purpose

Monitor Long Operations inside an Oracle Database using Perl/DBI. This can be useful for monitoring Table Scans, Index Rebuilds, and Exports.

Source Code

http://ba6.us/CodeExamples/Perl-LongOps

This set of scripts gathers lag information from the GoldenGate GGSCI utility and graph the results via GnuPlot. (Work in progress) I have a codebase that works on Linux with GGv8 SHOW INFO format. Needs to be reviewed to check compatibility with GGv11. I can supply code or collaborate if you would like to help with updating this code.

I haven't look at Oracle's Remote Diagnostic Agent (RDA) tool in a couple of years. Back when we ran our systems on Windows I remember using a clunky version of RDA that looked like it was cobbled together with batch files and VB code. What is RDA? From the Oracle website:

Statspack Reports can be useful for diagnosing performance problems, but they are only useful if they are generated and available!

Did you know you can make your own Long Running Operation that is available to the V$SESSION_LONGOPS system view?

At the bottom of the Oracle documentation for DBMS_APPLICATION_INFO is some example code: http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_ap...

In a previous post I posted Perl source code for a script that monitors V$SESSION_LONGOPS and reports progress of all current long operations: TODO

– Dave

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. Read more »

I recently discovered that someone else is publishing some Perl utilities to monitor Oracle!

I've been using Perl to get things done with Oracle for a while and have found it extremely helpful. The current environment that I work in has a mixture of OSes so sometimes its easier to install Perl and DBI everywhere and write a simple Perl Script than to try to do something in DOS Batch for one client and then do it again in a bash shell script for another.

Sean Hull published a video of his talk about otop, the PowerPoint slides, and the downloadable source on his company's site: Read more »