Re: FTS, LRU/MRU and X$BH

  • From: Martin Berger <martin.a.berger@xxxxxxxxx>
  • To: rjoralist@xxxxxxxxxxxxxxxxxxxxx
  • Date: Mon, 12 Jan 2009 19:48:20 +0100

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.



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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2009