ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle AWR Top SQL section

Oracle AWR Top SQL section

原创 Linux操作系统 作者:yxyup 时间:2008-04-20 11:51:30 0 删除 编辑

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/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-06

  • 博文量
    163
  • 访问量
    1361027