Re: Basic Scripts for Database Administration
From: exazonk <exazonk_at_gmail.com>
Date: Thu, 25 Jun 2009 16:54:47 -0700 (PDT)
Message-ID: <f8f66333-5703-4f62-a227-24d3955657cc_at_x29g2000prf.googlegroups.com>
> 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.
Date: Thu, 25 Jun 2009 16:54:47 -0700 (PDT)
Message-ID: <f8f66333-5703-4f62-a227-24d3955657cc_at_x29g2000prf.googlegroups.com>
> 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.
9i OEM seems like more trouble than it is worth! So, I didn't really bother with it. I haven't investigated the higher versions which is part of the reason for this thread, eg, to see if there really is some valuable stuff out there instead of custom scripts.
I'd go far as to say that I hate Toad! Extremely cluttered and expensive. I do most things from commands run through sqlplus. I also prefer to run basic monitoring on the DB server, keep in mind that I usually only work on Sun and HP-UX systems. Received on Thu Jun 25 2009 - 18:54:47 CDT