Re: FTS, LRU/MRU and X$BH
Date: Mon, 12 Jan 2009 19:48:20 +0100
Message-Id: <3AA5C097-D62C-4A03-AC7E-1CC411A170BA_at_gmail.com>
Rich,
you can also check V$SEGMENT_STATISTICS http://download.oracle.com/docs/cd/B14117_01/server.101/b10755/dynviews_2060.htm#REFRN30220 what kind of reads where done on this.
hth
Martin
> Ahhh...yes, that would account for this. I also have a non-parallel
> version
> of the query that I'll check to verify as well.
>
> Thanks, Jaromir!
>
> Rich
>
>> Hi Rich,
>>
>>
>>> I confirmed that the docs at
>>> http://tinyurl.com/a6n4bz say FTSing will cause blocks to be put
>>> on the
>>> LRU end of the buffer cache, so I expected to at least see them at
>>> some
>>> status.
>>
>> Please check the DEGREE of the table. One explanation could be you
>> use a
>> parallel select and therefore a direct path read.
>> http://download.oracle.com/docs/cd/B19306_01/em.102/b25986/oracle_database.htm#sthref1922
>> In doubts, re-run the select with NO_PARALLEL hint.
>>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 12 2009 - 12:48:20 CST
- application/pkcs7-signature attachment: smime.p7s