Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> High number of version counts for a block
Hi :
I ran the following query to identify the number of versions of a block .
The Block 40462, File#16 has 23 versions in CR mode. My question is why is
there 23 versions of BLOCK - 40462, FILE# 23 when there are no
updates,deletes,inserts going on in that table. This is a static table and
is in the KEEP POOL. Only selects are occuring against this table since DB
startup.
select count(*),file#,block#,status from v$bh
group by file#,block#,status having count(*) > 5
order by 2,3,1;
COUNT(*) FILE# BLOCK# STAT
---------- ---------- ---------- ----
9 1 20178 cr 8 10 740 cr 23 16 40462 cr17 16 40636 cr
COUNT(*) FILE# BLOCK# STAT
---------- ---------- ---------- ----
6 79 30775 cr 6 79 30798 cr6 79 30799 cr
22 rows selected.
I ran a query to identify which objects are present in which pool. If the CR blocks of the objects in the KEEP buffer pool are created in DEFAULT buffer pool , I am not seeing any blocks belonging to the above object FILE 16 BLOCK 40462 any where in the DEFAULT buffer pool. Can anyone tell me where I am going wrong ? Received on Tue Oct 31 2000 - 22:25:55 CST
![]() |
![]() |