RE: Suggestions for monitoring tools?

  • From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
  • To: <janine@xxxxxxxxxx>, "Sean Hull" <shull@xxxxxxxxxx>
  • Date: Tue, 3 May 2005 13:16:13 -0400

Over the last 2 1/2 years I have been working on my own "Oracle Monitoring & 
Alerting" program called "HEYMONitor".
I have used it myself for two different clients and works very well.

HEYMONitor keeps me well informed about what bad things are happening to the 
database when I'm not looking at it.
As the web site indicates, HEYMONitor is not a "dashed board" program like 
Spotlight...I use Spotlight everyday and would  never give it up, but rather 
HEYMONitor will Alert me when it is time to look at Spotlight or get a SQL*Plus 
session going.

HEYMONitor is very Oracle centric both in design and use, but your an Oracle 
DBA, so that is good! ;o)
I say that because many of my very good SysAdmin's tell me they (their tools) 
"look" to see if my Oracle process are "up".
We as DBA know that an Oracle database can be up, but totally unusable.  I also 
have SysAdmin friends that show me the power of other very good enterprise 
based Monitoring & Alerting tools.  These are great tools but I have to install 
them and most are just very  good "parse" tools...I have to write the advanced 
code logic to determine what is going on internally with my Oracle I just wrote my own tool.

I'm a full time DBA and part-time (barely-time) developer.  So HEYMONitor has a 
couple of small issues and a lot I would like to add or modify, but again I 
rely on it everyday and am able to know the availability of my databases.
I will send you off line an old picture of my email Inbox that shows the 
logical chain of events caught by HEYMONitor as a RAC database spirals out of 
control and terminates.

The HEYMONitor Server software (TAR) and information can be found at

About HEYMONitor?
HEYMONitor? is a freeware "Oracle Monitoring & Alerting Solution" Program.
HEYMONitor? can Monitor & Alert for Oracle PROCESSES, DATABASE, and LOG FILES.
Once installed and configured it will take only minutes to add A 
Remote Oracle Database for total Oracle Monitoring & Alerting.

hth, Good Luck and let me know what you think.

Chris Marquez
Oracle DBA
HEYMONitor? -
"Oracle Monitoring & Alerting Solution"

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Janine Sisk
Sent: Tue 5/3/2005 11:26 AM
To: Sean Hull
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Suggestions for monitoring tools?
Hi Sean, thanks for dropping in!

On May 2, 2005, at 11:02 AM, Sean Hull wrote:

> I have
> some scripts I use, and was thinking of releasing a more general plugin
> which can be configured to do just about any query, and check results. 
>  If
> you're concerned about the overhead of reopening connections to Oracle
> each time you to a db check, you can use mod_perl with Apache to make
> connections persistent.

I would be happy to beta-test any releases you care to put together, if 
you decide to go ahead.  What I need is something similar to Karma, 
that will warn me if something is amiss.




Other related posts: