Oracle Health Checks Scripts

Please find below blogs which can be useful for HealthCheck Scripts

http://docs.oracle.com/cd/B28359_01/server.111/b28310/diag007.htm --> From 11g

http://www.oracle-base.com/dba/Scripts.php
http://arjudba.blogspot.com/
http://vsbabu.org/oracle/
http://www.idevelopment.info/cgi/ORACLE_dba_tips.cgi

In addition to my first reply DB heatlh check (oracle sanity check) includes:

- check undo/temp/flashback configurations
- review non-default init parameters
- review shared memory setup
- check backup and recovery status/strategy
- check available space in tablespaces
- check if table/index statistics are currect
- check if tables might benefit from shrinking
- review security – unlocked user/ weak passwords
- check if there are indexes that are redundant / not ever used
- check if there are no missing indexes (ex. for fk)
- The presence of ORA-600/7445 errors in the alert log?
- Are any tablespaces nearly full (without autoextend)?
- A test of I/O throughput against some benchmark?
- A test of SQL response time against some benchmark (ala OEM)?
- ask customer/users about any known issues
- Licencing Audit
- Review of patch or even version status
- Check logs for oddities
- check for invalid objects
- review of performance, look at whole tuning arena
- Security
- suitability of backup strategy

Got from Niall Litchfield sir in a thread in  Oracle Forum