RE: 3rd Party Database health check

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Wed, 4 Feb 2004 13:35:39 -0500
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA656D8153@25exch1.vicorpower.vicr.com>

I've looked at Patrol, TeamQuest, Tivoli, and a pile of others. Many = have some rather strange things that they watch & alert on (like BCHR) = while at the same time missing what I think are more important items = like processes, sessions, and archive redo space. Guess that's why the = program I wrote many moons ago is still alive & well here. One good = thing about rolling your own, you own the source code. Don't like what = it's watching or where the alert points are, change them.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Kirtikumar Deshpande [mailto:kirtikumar_deshpande_at_yahoo.com] Sent: Wednesday, February 04, 2004 1:29 PM To: oracle-l_at_freelists.org
Subject: RE: 3rd Party Database health check

About 6 years ago, I installed BMC Patrol at our workplace for DB = monitoring.=20

Last year we began uninstalling it as we migrated/upgraded databases to = newer releases. Patrol was
a bit late to keep up with all new features.=20 =20
This year we stopped running Patrol on almost all servers for DB = monitoring (a few are still
running it as I have not found time to get to them).=20

>From all those 60-100 "database parameters" Patrol monitored, we had =
found about 10 or so to be of
any help to the DBA with Oracle 7 and 8, mainly. =20

Now we are deploying our own scripts to monitor just a few parameters we = think are critical to
each database: archived and dump directory usage, listener status, = tablespace usage, interested
ORA errors in alert log etc.=20

Cheers!

• Kirti =20

=20

• "Mercadante, Thomas F" <thomas.mercadante_at_labor.state.ny.us> wrote:
  > We just looked at Tivoli Monitoring for Oracle. The sales =
  presentation
  > sounded good. But when we started looking at what exactly they could
  > monitor "out of the box", we rejected everything except for database
  > up/down, listener up/down and archive directory getting full. It had =
  a
  > bunch of Oracle internal things it could monitor (like tablespace =
  filling
  > up, user process monitoring etc, but we just didn't want to implement =
  a
  > monster, and some other stuff just didn't make any sense (like =
  BCHR). And
  > we thought that it would be sending us way too many emails or pages to =
  turn
  > anything else on.
  >=20
  > Just my 2 cents.
  >=20
  > Tom Mercadante
  > Oracle Certified Professional
  >=20
  >=20
  > -----Original Message-----
  > From: Niall Litchfield [mailto:n-litchfield_at_audit-commission.gov.uk]
  > Sent: Wednesday, February 04, 2004 10:40 AM
  > To: oracle-l_at_freelists.org
  > Subject: 3rd Party Database health check
  >=20
  >=20
  > Does anyone have any experience of these, what sort of things got =
  looked
  > at and what stuff didn't get looked at? We have had 2 that seemed to =
  be
  > somewhat useless and annoying, I am not sure that this is because they
  > are useless and annoying or if we were just unlucky. I don't mind folk
  > checking that we backup our databases for example, but passing our
  > backup strategy without seeing whether it worked or not doesn't =
  inspire
  > confidence
  > =20
  > Niall Litchfield
  > Oracle DBA
  > Audit Commission
  > +44 117 975 7805=20
  >=20
  >=20
  

  ---

Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Feb 04 2004 - 12:35:39 CST