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.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/7364032/viewspace-245927/ ,如需转载,请注明出处,否则将追究法律责任。