Determining High-Load SQL Statements with ADDM

High-Load SQL Statements may cause serious performance problem, reducing significantly throughput of your database system. So, it�s a good thing to monitor your database, identifying high-load SQL statements. To simplify this task, Oracle Database offers Automatic Database Diagnostic Monitor (ADDM) that you can use to automate the task of finding potential high-load SQL statements and receiving recommendations on how to fix the problem identified.

Read this article...

comments powered by Disqus