Oracle AWR Top SQL section

Top SQL

This section displays top SQL ordered by important SQL execution metrics. The top SQL section in the AWR report contains lists of SQL statements ordered by the following criteria:

Elapsed Time: Statements are ordered according to elapsed execution times.

CPU Time: Statements are ordered according to CPU time.

Buffer Gets: Statements are ordered according to logical reads number.

Physical Reads: Statements are ordered according to physical reads number.

Execution Number: Statements are ordered according to execution number.

Parse Calls: Statements are ordered according to parse number.

Version Count: Statements are ordered according to version number.

Sharable Memory: Statements are ordered according to sharable memory consumption.