Re: What tools do you use for healthchecking?
Date: Wed, 18 Feb 2009 13:59:01 +0000 (UTC)
Message-ID: <gnh475$3gi$3_at_solani.org>
On Wed, 18 Feb 2009 11:28:00 +1100, Noons wrote:
> You could look at Symantec's I3. That works with just about any version
> of Oracle, does an excellent job of monitoring as well as helping with
> any tuning. It'd have been my first choice, but I was over-ruled by the
> PTB to use grid.
I agree. OEM is cumbersome, difficult to configure, very expensive to run, unresponsive and slow. I can also recommend Quest SpotLight but I was in a similar situation, caused by another PHB.
The real OEM killer is Nagios. It has Oracle plugins, written in Perl and can be used monitor just about any aspect of the database. The downside is that it requires an experienced DBA who will produce Perl scripts as needed. What makes Nagios a potent OEM killer is the fact that it is free, the magic word in today's pauperized world.
Small digression here: I noticed that despite Jared's best efforts, the fine art of writing Perl scripts is gradually being lost among the DBA personnel. That's sad because I don't really like the replacement language (Python). Of course, if Perl continues to decline, I will have to stop worrying and learn to love Python. Peace on Earth!
-- http://mgogala.freehostia.comReceived on Wed Feb 18 2009 - 07:59:01 CST