Oracle database environments can be very complex. Frequent checks of overall database help improve performance, reduce down time and help plan properly for the short term and long term goals. Here is a sample Oracle Health Check Report
At a high level, here are broad areas to perform health check
- OS Level - patches, kernel parameters, optimization
- I/O Analysis - Understand how your database is distributed across hard drives and impacting the performance.
- Network traffic analysis - Check for Network bottlenecks
- Backup and Recovery Strategy - Check if the backup strategy is still good with availability goals of the business. Plan for frequent restore tests.
- Security - Check for recent security patches and updates
- Logs, traces, Cores - Check for back ground processes errors before they become major problems.
- Performance check - A quick check of log switches to understand peak hours (writes) and top SQL's to understand most impacting SQL's, Hit ratios, fragmentations, Waits, contentions, Table scans, etc.
- Oracle parameters - check if those settings still make sense
- Advanced Configuration - check RAC, Replication, Standby Database
- Check Oracle performance indicators using performance stats reports.