X$BH TABLE

From: Bunyamin K.Karadeniz <bunyamink_at_havelsan.com.tr>
Date: Wed, 21 Mar 2001 03:57:56 -0800
Message-ID: <F001.002D2E1D.20010321035533@fatcity.com>

CAN ONYBODY EXPLAIN ME ,
   when ż query x$bh table as a state
field , I get 0,1, or 3. What do these values mean? And in the query

select decode(state,0, 'FREE', 1, decode(lrba_seq,0,'AVAILABLE','BEING USED'),
3, 'BEING USED', state) "BLOCK STATUS", count(*) from x$bh
group by decode(state,0,'FREE',1,decode(lrba_seq,0, 'AVAILABLE','BEING USED'),3, 'BEING USED', state); BLOCK

STATUS                              
COUNT(*)---------------------------------------- 
---------AVAILABLE                                     

3928BEING

USED                                      

72
You see  I do not have FREE blocks . Is it a problem.?
     Thanks 
  Received on Wed Mar 21 2001 - 05:57:56 CST