RE: Database Health Review

[Mark Leith]

*User Response Times!*

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Vidya Kalyanaraman
Sent: 08 January 2004 08:40
To: Multiple recipients of list ORACLE-L
Subject: Database Health Review

Hi
 I am supposed to be doing a database health review for one of the customers.  They have Oracle database  ver9.2.0.3 on HP UX 11i.
 Normallly, we do check the following:
�    OFA standards
�    Purging Strategy
�    Archival Strategy
�    Database server utilization (shared pool area)  - Run Statspack
�    Latest certified combination of Oracle Products.
�    Transaction Management (RBS, Redo)
�    OLTP init.ora parameters
�    Optimizer statistics
�    Custom Code Management
�    NLS Setup
�    Server and storage area configuration.


 Did I miss out on anything?
 Any comments/suggestions/pointers are most welcome.

Thanks and Regards
Vidya