Re: lru_flag in x$bh

From: Nigel Thomas <nigel_at_preferisco.com>
Date: Thu, 15 Jun 2006 07:13:03 -0700 (PDT)
Message-ID: <20060615141303.35662.qmail@web54707.mail.yahoo.com>

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

Received on Thu Jun 15 2006 - 09:13:03 CDT