Amir

>> Does anyone know what "lru_flag=6" means in x$bh view? I can interpret
>> 0,1,2,4 and 8 but not 6. I am running 9.2.0.6. Any help will be
>>appreciated.

I presume it's a flag byte - so each bit means something independently

6 = ( 4 | 2 ) (ie binary 00000110)

ie *both* of the conditions implied by LRU_FLAG=4 and LRU_FLAG=2 are true.

Or you could use the very helpful definition from Burleson's Elite Oracle Training site [http://www.oracle-training.cc/oracle_tips_view_columns.htm] :-)

"LRU_FLAG
The LRU_FLAG column of X$BH contains information about LRU state of a block in the buffer cache, but this column does not reveal much useful information."

Regards Nigel
--
http://www.freelists.org/webpage/oracle-l