RE: direct path read & db_file_multiblock_read_count

  • From: Fergal Taheny <ftaheny@xxxxxxxxx>
  • To: Amir.Hameed@xxxxxxxxx
  • Date: Fri, 25 Oct 2013 23:56:32 +0100

Hi,
Is it because lots of the table's blocks are already in the buffer cache
and the direct path reads vary the read sizes to avoid reading blocks that
are already in cache. If you flush the buffer cache and rerun the query do
you get more 128 block reads?

Fergal


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


Other related posts: