X$BH TABLE

[Bunyamin K.Karadeniz]

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                                     3928 BEING USED                                      72 You see  I do not have FREE blocks . Is it a problem.?      Thanks