| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: monitoring multiple databases using PL/SQL
Dennis,
True, but you should also consider...
"In a decentralized configuration, the monitoring software or scripts reside with the database. This complicates maintenance, but allows for higher monitoring availability."
I believe that your better off somewhere in the middle.
You can host a set of PL/SQL procs in a "monitoring" schema on each database server to check the basics of the database, and report back to you. In this configuration, you can enhance and add features to the development version, and make sure it works, before updating all the databases. Du'oh!! Configuration Management!!!
And then you can host specific "are you up/bogus login" scripts on a central host.
Generally, your Oracle database stays up...since it's not SQL Server...du'oh!!! The majority of the database problems are in the database, ie. maxextents, no space, performance, blah, blah...there is a list in my paper.
Don't forget to collect all this monitoring data in some table(s), as it will become useful.
And be sure to CC your boss on all the benefits your monitoring services provide you. Hopefully, some funding will eventually be thrown your way to get a decent monitoring product.
Also, recently I saw a demo of a monitoring product called AutoDBA. It is very slick, almost like having a junior DBA doing all the boring, monitoring, dirty work. Except it doesn't get your coffee for you...or wash your car...or...
HTH. Chris Grabowy
DISCLAIMER: I am not in any way associated with the makers of AutoDBA. My paper also includes a list of other monitoring products.
-----Original Message-----
Sent: Tuesday, April 23, 2002 1:53 PM
To: Multiple recipients of list ORACLE-L
>From 'Oracle Database Monitoring for the Beginner' (pdf) - Chris Grabowy
"In a centralized configuration, the monitoring software scripts reside on one server. This obviously makes maintenance easier, but if the hosting server fails then there is no (more) monitoring of the databases"
regards
Madhu
>From: dmeng_at_focal.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: monitoring multiple databases using PL/SQL
>Date: Tue, 23 Apr 2002 08:00:33 -0800
>
>Greetings -
>I am planning to centralize our Oracle monitoring process by using one
>PL/SQL procedure to query database extents, invalid objects, alert logs etc
>through database links. I wonder if anybody has done it before and if there
>is any cons with it. The pros would be ease of administration, ease of
>standardization etc.
>
>TIA
>
>Dennis
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: dmeng_at_focal.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Madhusudhanan Sampath INET: madhulist_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: cgrabowy_at_fcg.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Apr 23 2002 - 17:28:23 CDT
 |
 |