How to Read or Analyze an AWR Report in Oracle -4 | TOP SQL

Hi,

I will continue to explain How to Analyze or Interpret an AWR report in Oracle in this article.

Read previous Articles before this.

https://ittutorial.org/how-to-analyze-an-awr-report-in-oracle-3/

SQL Statistics

One of the most important sections of the AWR reports is the section that provides most resource consuming SQLs ( called TOP SQLs ). This section lists the TOP SQLs according to the following criteria. .

SQL ordered by Elapsed Time

First TOP SQL section is SQL ordered by Elapsed Time which includes Top Elapsed times SQLs. Top elapsed time SQLs are ordered according to elapsed time that took maximum execution time during processing

SQL ordered by CPU Time

This section lists the most CPU-consuming SQLs in the database. SQL that spend the most CPU time are candidates for SQL Tuning, they are immediately examined and if it is problem , then SQL Tuning is done.

SQL ordered by User I/O Wait Time

This section lists SQLs ordered by User I/O wait time in the database.

SQL ordered by Gets

This section lists SQLs ordered by Gets that TOP logical reading SQLs from Buffer Gets in the database

SQL ordered by Physical Reads (UnOptimized)

This section list the SQLs that perform the highest Physical I/O in the database. The tables that are used by queries that make physical I / O in this section are generally non-indexed. If so, index is created on the related tables and related column.

SQL ordered by Executions

This section list the SQLs that perform the highest executions in the database. Most executed SQLs are candidates for SQL Tuning, they are immediately examined and if it is problem , then SQL Tuning is done.

You can access details of SQLs ( Full text SQL )  by clicking SQL ID in the TOP SQL Sections like following.

Do you want to learn Oracle Database Performance Tuning detailed, then read the following articles.

https://ittutorial.org/oracle-database-performance-tuning-tutorial-12-what-is-the-automatic-sql-tuning-and-how-to-automated-sql-tuning/