-
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|