The wealth of information provided by Exadata can be overwhelming to learn and master. Many people fall into the trap of monitoring a plethora of metrics, misleading them into focusing on and fixing the wrong problem! DPA makes your Exadata deployment much easier by providing clear visibility of the metrics that have a direct correlation to performance.
Regardless of hardware, this old adage is true: bad code and bad architecture (even on Exadata) is still bad. DPA for Oracle gives you the ability to not only identify performance bottlenecks, but also communicate the actual root cause of the performance issues to others. This accelerates problem identification, and also provides baseline metrics to validate the effectiveness of any changes.
The benefits of Exadata for online transaction processing (OLTP), even with its new smart flash cache, are not fully realized if the smart flash cache is not properly configured. Beyond the obvious flash cache hit ratio, the block read latencies provided by DPA for Oracle are one of the most effective measures of cache performance.
As Tanel Põder points out in the book, Expert Oracle Exadata, "… in order to avoid wasting effort on fixing the wrong problem, we really need to measure what matters! For database performance, nothing matters more than response time, …".
Call us at 866.530.8100
Email us at Sales@SolarWinds.com