Re: What tools do you use for healthchecking?
From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Tue, 17 Feb 2009 09:04:40 -0800 (PST)
Message-ID: <ccbd836f-4b77-49dc-a44b-3a8ed7571a41_at_f3g2000vbf.googlegroups.com>
On Feb 17, 5:47 am, Helma <helma.vi..._at_hotmail.com> wrote:
> Hi,
>
> For the earlymorning check, I am working with self made scripts here
> that run overnight and check for things like space in the database,
> security, backup ran ok, duplicates to testenvironments,
> errorlogchecking etc.
>
> These scripts are a bit... wel... 20th century.. I am looking for
> tools that can check. For example, i am now looking at the healthcheck
> of TOAD, but that frog is more into developing (e.g. checking for
> unindexed foreign keys) than administration.
> Apart from Oracle, I am also looking for UNIX solutions.
>
> What do you use for this?
>
> regards,
> HV
Date: Tue, 17 Feb 2009 09:04:40 -0800 (PST)
Message-ID: <ccbd836f-4b77-49dc-a44b-3a8ed7571a41_at_f3g2000vbf.googlegroups.com>
On Feb 17, 5:47 am, Helma <helma.vi..._at_hotmail.com> wrote:
> Hi,
>
> For the earlymorning check, I am working with self made scripts here
> that run overnight and check for things like space in the database,
> security, backup ran ok, duplicates to testenvironments,
> errorlogchecking etc.
>
> These scripts are a bit... wel... 20th century.. I am looking for
> tools that can check. For example, i am now looking at the healthcheck
> of TOAD, but that frog is more into developing (e.g. checking for
> unindexed foreign keys) than administration.
> Apart from Oracle, I am also looking for UNIX solutions.
>
> What do you use for this?
>
> regards,
> HV
For 9i the Toad scripts are one option and you can ( assuming relatively current on Toad ) easily turn off or customize the parts that don't make sense for your environment. Received on Tue Feb 17 2009 - 11:04:40 CST