Re: lru_flag in x$bh

From: Nigel Thomas <nigel@xxxxxxxxxxxxxx>
To: Amir.Hameed@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 15 Jun 2006 07:13:03 -0700 (PDT)

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

References:

lru_flag in x$bh
From: Hameed, Amir

Re: lru_flag in x$bh

Other related posts: