SQL ordered by Gets 中的Buffer Gets 、Executions、Gets per Exec、%Total 、Elapsd Time (s)、Old Hash Value的含义是什么?
我理解:
Buffer Gets 请求的块数(物理读+逻辑读)
Executions 执行的次数
其他的从字面上看不出来?请问含义,谢谢!!
CPUElapsd Old
Buffer GetsExecutionsGets per Exec%TotalTime (s)Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
489,059
722
677.4 86.4 903.5268424.06 2532670789
Module: SQL*Plus
SELECT MAX(OBJECT_ID) FROM T WHERE T.OBJECT_ID BETWEEN TRUNC(DBM
S_RANDOM.VALUE(1,20000)) AND TRUNC(DBMS_RANDOM.VALUE(300000,5000
0))