Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Suggestions for monitoring tools?

RE: Suggestions for monitoring tools?

From: Marquez, Chris <>
Date: Tue, 3 May 2005 14:55:27 -0400
Message-ID: <B30C2483766F9342B6AEF108833CC84E0450BB07@ecogenemld50.Org.Collegeboard.local>

>>Are you trying to go the way of EZSQL, or TORA?

Having my url redirect to I'm a long way from that...

Besides all the big boys are spending their time *trying* to "sell" (notice I didn't say "develop") a Enterprises product that will monitor, report, graph, and alert from client session all the way to the disk drive.

I have only seen one come close and think there are a lot free-ware tools that do 75% of what commercial if charging big bucks for?


-----Original Message-----
From: Ron Rogers [] Sent: Tue 5/3/2005 2:17 PM
To: Marquez, Chris;; Cc:
Subject: RE: Suggestions for monitoring tools?  

  A nice collection of handy "tools" and displays. Thanks for sharing it with us.  Are you trying to go the way of EZSQL, or TORA? Good luck. Ron

>>> "Marquez, Chris" <> 05/03/05 1:16 PM >>> Janine,
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: on behalf of Janine Sisk Sent: Tue 5/3/2005 11:26 AM
To: Sean Hull
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.




Received on Tue May 03 2005 - 14:59:50 CDT

Original text of this message