|
session cursor cache hits : Number of hits in the session cursor cache. A hit means
that the SQL (including recursive SQL) or PL/SQL
statement did not have to be reparsed. Subtract this
statistic from "parse count (total)" to determine the real
number of parses that occurred.
从session cursor cache hits的定义来看,session cursor cache hits 应该小于parse count (total)。
如下是系统环境:
redhat 6.5 X86_64 SGA:50g PGA:20G
oracle:11.2.0.3 双结点RAC。
结点1结果:
结点2结果:
结点2的结果来看明显session cursor cache hits要大于parse count(total),求大神帮忙解释一下。
|
|