To see the status of database block buffer cache in the SGA, you can query to
'X$BH'.
Determining the size of DB_BLOCK_BUFFERS parameter I usually used following SQL
statement as logged in SYS.
select decode (state, 0, 'Free', 1, 'Read and Modified', 2, 'Read and not
Modified', 3, 'Currently Being Read', 'Other'), count(*)
from x$bh
group by decode (state, 0, 'Free', 1, 'Read and Modified', 2, 'Read and not
Modified', 3, 'Currently Being Read', 'Other');
Received on Thu Apr 16 1998 - 20:02:10 CDT
