| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> How to translate the value of state in the X$BH?
Are the following assumption correct??
SQL> select state, count(*)
2 from x$bh
3 group by state;
STATE COUNT(*) Assumption
--------- --------- --------------------
0 2 Total blocks NOT been used ?
1 3968 Total blocks used ?
3 30 ?
----------
4000 Total DB_BLOCK_BUFFERS
Regards,
Reza Abouk Received on Fri Mar 07 1997 - 00:00:00 CST
![]() |
![]() |