Re: FTS, LRU/MRU and X$BH
- From: "jaromir nemec" <jaromir@xxxxxxxxxxxx>
- To: <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 12 Jan 2009 18:35:22 +0100 (CET)
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
Other related posts: