One reason for seeing more db_block_gets
than you expect on a full segment scan
is that every extent map block (of which
the segment header block is just one)
is accessed differently. If you have small
extents and large objects, you may have
overshoot the maximum extents allowed
in the segment he
Jonathan Lewis,
Thanks very much for your reply. Yes, in oracle 8i on sun solaris, the
db block gets of fulltable scan is always 4block, no matter what the size of the table
is. But in my tests in linux/817, it always show 12(8170 and 8172).I run the full scan
again and again, bu
