Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: HP Open view

RE: HP Open view

From: Allen, Brandon <>
Date: Wed, 22 Aug 2007 12:51:05 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C4508B6E5EB@NT15.oneneck.corp>

We use it for everything here (Windows, Unix, Oracle, SQL Server, Informix, Network, etc.) and it's okay in that it's a centralized tool for checking everything, but it's not as flexible as I'd like when it comes to who gets notified for alerts and how. I prefer to rely on my custom scripts to alert me by email & cell phone text message and then I can easily customize it however I want depending on who should get the page (who is on-call that day?), what information the message should contain, etc. OVOW just seems a little too rigid and cumbersome to me, but it's possible that I'm just not fully aware of all the possibilities. We've had it for a while, but we already had custom monitoring in place for all our databases long before the implementation of OVOW so we DBAs have been slow to fully adopt it - it's one of those things that always seems to be "on the back burner".  

Another annoyance is that it can be very slow, particularly when you use the fat client (vs. the web console) and you try to bring up a lot of acknowledged messages.  

Oh, and one more thing - some of the queries it runs to check on your databases, e.g. the queries on dba_free_space, dba_extents, etc. can cause a pretty significant load on your database, depending on your DB version, LMT vs. DMT, number of objects in your database etc. So, you'll want to monitor after implementing the DBSPI for Oracle and make sure it's not bogging things down too much. I disabled some of the metrics and set others to run less frequently because of this.  

I think it's preferable to use the built-in monitoring of 10g if possible.  


[] On Behalf Of Jack van Zanen Sent: Wednesday, August 22, 2007 5:54 AM To:
Subject: HP Open view

Hi All,    

I have just started a new job and have to set up monitoring for the oracle/Sybase and sql server environment. Just the usual stuff (listener up/down, database up/down, alert log monitoring, availability of resources etc.). But they have HP open view and like everything to be monitored using this tool.

Let's focus on oracle for now, as this will be my first task, does anyone have experience with HP Open view and alerts/monitoring of oracle database environments?

Any horror stories, gotcha's etc etc?    



Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

Received on Wed Aug 22 2007 - 14:51:05 CDT

Original text of this message