I will continue to explain How to Analyze or Interpret an AWR report in Oracle in this article.
Read previous Articles before this.
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.