Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Grid Control - opinions please

RE: Grid Control - opinions please

From: Baumgartel, Paul <>
Date: Thu, 6 Apr 2006 10:49:05 -0400
Message-ID: <>

Jared, I couldn't agree more. I stick to SQL scripts and SQL*Plus to do 99% of my work. Reliable, effective, keeps my knowledge current.  

Paul Baumgartel

-----Original Message-----
From: []On Behalf Of Jared Still Sent: Thursday, April 06, 2006 10:44 AM
To: Jason Heinrich
Cc: Oracle-L Freelists
Subject: Re: Grid Control - opinions please

Comments below:

On 4/6/06, Jason Heinrich < <> > wrote:

That said, things aren't all sunshine and roses. Running in a browser does limit you to only working on one target at a time, though you could open multiple browser tabs to get around this. Certain targets have a bad habit of going into "Status pending" or "Metric collection error" status for no apparent reason; and I'm having the same issue as Jeffrey Beckstrom, where GC won't send me notification emails, even though everything appears to be setup properly. Finally, I haven't found a way to display a list of sessions on a database without using the Diagnostics Pack.

I can't help myself here, as there are now multiple complaints about the notifications.

The Perl/shell/SQLPlus/PLSQL daemons and/or scripts run from cron have for several years been monitoring databases that I am in responsible for. (Mostly Perl)

Among the things monitored:

No doubt many DBA's have reliable home grown scripts and processes for monitoring and managing databases.

A GUI is no substitute for knowing how the database works.

The scripting approach has an advantage that OEM/GC or any other tool has: you are not dependent on a vendo (Oracle or anyone else) to fix or support their tool so you can do your job.

You can create tools to do exactly what you need. If your needs change you can modify them. When they break, you can fix them.

If you made it this far, thanks for reading all this.

And perhaps you can understand the apprehension felt by many when attempting to use some of the 'time saving' tools, and the reluctance to give up tried and true methods.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist 

Please access the attached hyperlink for an important electronic communications disclaimer:

Received on Thu Apr 06 2006 - 09:49:05 CDT

Original text of this message