第一步:执行如下语句:
SELECT phy.value as "physical reads" ,cur.value as "db block gets",con.value as "consistent gets"
FROM
V$SYSSTAT PHY,
V$SYSSTAT CUR,
V$SYSSTAT CON
WHERE
PHY.NAME='physical reads'
and cur.name='db block gets'
and con.name='consistent gets'
结果:
physical reads| db block gets| consistent gets
-------------------
----------------------
----------------------
2062
4589
181757
第二步:执行如下语句:
select sum(physical_reads) as "physical reads" ,sum(db_block_gets) as "db block gets" ,sum(consistent_gets)as "consistent gets" from V$buffer_Pool_Statistics
结果:
physical reads| db block gets| consistent gets
-------------------
----------------------
----------------------
2044
109020
104183
【问题】
为什么统计信息会不一致??
|