Exadata is a significant investment for any customer and one should make sure to maximize investment by configuring Exadata machine as per best practices and utilize all the features of engineered systems. Oracle has provided an array of tools for Exadata machine, but we see a gap between standard Exadata configuration vs a truly optimize Exadata machine. Exachk is a great tool provided by Oracle to validate Exadata configuration and Oracle best practices, but it’s designed as a standard tool for all Exadata machines. Exachk is not specific to a particular type of workload or application and doesn’t investigate enchantment opportunities to achieve extreme performance from Exadata machine.
That is why you should perform a detail Exadata health check of your Exadata machine which goes above and beyond Exachk validation and Oracle Enterprise Manager monitoring capabilities. The goal of this health check is to maximize the Exadata investment and reduce the number of incidents which can impact the availability of critical applications. Here is list of task you should perform to perform a detail Exadata Health check
- Review Exachk report to evaluate Exadata configuration, MAA Best practices, and database critical issues.
- Review various types of Exadata logs including Exawatcher, alert, trace, CRS, ASM, listener.
- Review Flash cache contents, verify smart flash log feature and check write-back cache functionality.
- Review Exadata feature usage like HCC Compression, Smart Scan, offloading, Storage Indexes
- Review Maximum Availability Architecture including backup of critical configuration files
- Review and validate Oracle Enterprise Manager Configuration of Exadata plugin.
- Review resource utilization at storage & database level and provide recommendations.
- Review AWR reports for contention and slow running processes.
- Review database parameter settings as per Oracle best practices including hidden parameters.
- Review log retention policy to optimize storage utilization and maintain historical data for troubleshooting any future issues.