Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database monitoring tools

RE: Database monitoring tools

From: Goulet, Dick <>
Date: Fri, 26 Nov 2004 21:38:26 -0500
Message-ID: <>

 I regret to say it, but Mamba as a free monitoring tool is dead. It now comes with a hefty rope attached for "remote DBA services". As for other monitoring tools, we use OEM's performance manager and a home grown Pro*C program. It has server well over the years & continues to do so. Also if your good at C try doing a monitoring tool in PHP (looks somewhat like & behaves somewhat like C, but with a WEB interface). You could also use HTML DB if you've got it setup. My situation was that damanagement wanted more "information" on what the DB's were doing, but they also did not want to spend any money and did not want anyone to be able to cause potential problems. Namely the tool had to be READ ONLY.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Leonard, George []=20 Sent: Friday, November 26, 2004 5:14 AM
To:; Subject: RE: Database monitoring tools

Statspak viewer ( has some graphic displ=3D
ays that hook into the V$ views,

There was also a web based tool called Mamba

George Leonard
Oracle Database Administrator
New Dawn Technologies @ Wesbank

You Have The Obligation to Inform One Honestly of the risk, And As a Pers=3D
You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit!

-----Original Message-----
[ ] On Behalf Of Antonio Belloni
Sent: 25 November 2004 19:47 PM
Subject: Database monitoring tools

Hi list,

We=3DB4ve been , for several years , monitoring and administering our Oracle databases with custom-made SQL scripts.=3D20

Using those scripts we are able to proactively avoid possible problems and everything works fine , performance is good , no one is complaining.

But , I don=3DB4t know why (maybe to show some nice hit ratios graphs to CIO) , management decided that we need a GUI tool to monitor our databases. I tried to deceive him from the idea , because we are a small shop (+- 10 instances , 50 Gb the largest one) and such tools are expensive , etc. But all my arguments were not sufficient to change his mind.

So , we are evaluating GUI tools and we=3DB4ve already looked at:

- BMC Patrol
- Quest Central
- Embarcadero=3D20
- OEM (with diagnostic , performance and change
management packs)

Funny , now management agrees with me and said that all they are expensive tools.

So , I wish to know what you guys are using to monitor and administer your databases , if there is open-source monitoring tools (I=3DB4ve tested one called VROOM but , in my opinion , it su**s) and what you think about such tools. Maybe , with other points of view I can make him (the manager) to decide to keep using our scripts or dig in the pocket and buy the necessary tools.

Sorry for the long message and thanks in advance. Regards,
Antonio Belloni


Yahoo! Acesso Gr=3DE1tis - Internet r=3DE1pida e gr=3DE1tis. Instale o discador=3D

The views expressed in this email are, unless otherwise stated, those of

the author and not those of the FirstRand Banking Group an Authorised Financial Service Provider o=3D r its management. The information in this e-mail is confidential and is intended solely for=3D
=3D20the addressee.
Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribut=3D ion or any action taken or=3D20 omitted in reliance on this, is prohibited and may be unlawful. Whilst all reasonable steps are taken to ensure the accuracy and integrit=3D y of information and data=3D20 transmitted electronically and to preserve the confidentiality thereof, n=3D o liability or=3D20 responsibility whatsoever is accepted if information or data is, for what=3D ever reason, corrupted=3D20 or does not reach its intended destination.
=3D20 ________________________________
-- --
Received on Fri Nov 26 2004 - 20:33:45 CST

Original text of this message