Re: Basic Scripts for Database Administration

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Thu, 25 Jun 2009 11:13:44 -0700 (PDT)
Message-ID: <ef8f0323-29f8-4027-a361-6efd7c3b895e_at_n4g2000vba.googlegroups.com>



On Jun 25, 1:19 pm, joel garry <joel-ga..._at_home.com> wrote:

snip

> Be sure and take to heart admonitions about trusting scripts from the
> internet, or even support or the documentation.
>
> I used to collect scripts and drag them around with me, but eventually
> that became too much useless work to keep them updated, and too many
> turned out to be based on myths and legends.  Nowadays, if there are
> any problems I focus on them specifically, the monitoring is the least
> of it, dbconsole is good enough for the usual suspects.

I don't recommend it especially and we don't work this way here ... but one could do way worse if starting from scratch and "absolutely convinced" that one did want basic admin monitoring scripts that were not related/from OEM by looking at the Health Check stuff available from the Toad DBA module.

It is pretty configurable and you can leave out and not run as many of them as don't make sense. Of course the Toad DBA module is not free. Received on Thu Jun 25 2009 - 13:13:44 CDT

Original text of this message