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 > > > -- > //www.freelists.org/webpage/oracle-l > > -- //www.freelists.org/webpage/oracle-l
