On Apr 5, 3:30 pm, "Bobby" <bobby.ow..._at_talktalk.net> wrote:
> Hi,
>
> Yes, I know you're probably all fed up of newbie questions and
> vagueness regarding checking health of an Oracle server/database. But
> hopefully you'll forgive me for this one.
>
> I've been tasked with writing a generic component for doing an "Oracle
> Health Check" as well as a "SQL Server Health Check". The purpose of
> this is to add to our SLA system so that DBAs are informed when there
> are performance issues, or other "potential" problems. I am fine with
> SQL Server as i am very familiar with it, but have only just started
> looking at Oracle.
>
> Yes, this is very vague also and I apologise. I've looked through
> various documentation and there seems to be an overwhelming amount of
> information in places such as v$stat, v$lock. Loads of information
> regarding cache hit ratios, CPU time, etc.
>
> What i've decided to to is ask all of you expert DBAs in this posting
> for a recommendation of the top (possibly about 5 to 10) most common
> and useful stats/performance checks I can do on an Oracle database (or
> server). This will be generic as we cannot really build in
> functionality for all database schemas, usages, etc. Could anyone
> possibly let me know which figures may be useful in most installations
> of Oracle.
>
> Many thanks in advance.
>
> Regards
>
> Bobby
Why develop a health check module, when Toad already has one in its
commercial version? Just click the items you want to see and presto!
--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Apr 05 2007 - 08:45:08 CDT
