Hi,

I want to find how many DB blocks are cached and used and how many are left unused. I use the query:

select state,count(*) from x$bh group by state;

and U get:

STATE COUNT(*)
---------- ----------
0 24
1 9972
3 4

Does this mean that 24 blocks were never used? 4 awereused but are available...

Some people say this is not the right query...So how do I query the x$bh?

Thanx!