Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: monitoring multiple databases using PL/SQL
Having done db monitoring via links, cron jobs, dbms_jobs, and a few others I
finally did mine via C/Pro*C running on an NT workstation. Acts like a client,
gets at everything I want (with the help of some extproc) and has been extremely
reliable, robust and dependable. Not to mention a real pain in the ___ in the
middle of the night, but then it was programmed to be insistent.
Dick Goulet
____________________Reply Separator____________________ Author: "Madhusudhanan Sampath" <madhulist_at_hotmail.com> Date: 4/23/2002 9:53 AM
>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: INET: dgoulet_at_vicr.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 - 13:59:03 CDT
![]() |
![]() |