Oracle Health & Statistics

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 Received on Thu Apr 05 2007 - 08:30:38 CDT