buffer_gets为什么会上到7位数？

xzh2000

最初由 piner 发布
[B]本来就是累计值啊

上次不给你说过一次吗？ [/B]

晕，看了文档就湖涂了。

Yong Huang

最初由 xzh2000 发布
[B]
v$sql中这样讲，应该不是汇总的
...
BUFFER_GETS NUMBER Number of buffer gets for this child cursor [/B]

Are you thinking that "for this child cursor" means it's not accumulative? Why? "For this child cursor" means exactly that. It's the total number of buffer gets for this child cursor. This same cursor may have been executed by many sessions (or one session) many times.

Yong Huang

yannanqi

对啊，for the child cursur并不意味着就是执行一次。
坛子就是好，有时候理解容易有偏差，大家提醒一下就清楚了。呵呵

macro_zhang

up