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@xxxxxxxxx] Sent: Wednesday, February 04, 2004 1:29 PM To: oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxxxx] > Sent: Wednesday, February 04, 2004 10:40 AM > To: oracle-l@xxxxxxxxxxxxx > 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------