Re: FTS, LRU/MRU and X$BH

From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Mon, 12 Jan 2009 12:16:39 -0600 (CST)
Message-ID: <b7854c9ddd11ad9846ae46e8612e0277.squirrel_at_society.servebeer.com>

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.
>
> Regards,
>
> Jaromir
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

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

Received on Mon Jan 12 2009 - 12:16:39 CST