RE: Tim Gorman's "...Cost-Based Optimizer.doc"

  • From: "Khemmanivanh, Somckit" <somckit.khemmanivanh@xxxxxxxxxxxxxxxx>
  • To: <cmarquez@xxxxxxxxxxxxxxxx>, <mgogala@xxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 16 Jun 2005 10:36:02 -0700

Could it be that scattered reads take less time "if" the next block of
data to be read is "actually" adjacent to the last block read, therefore
you wouldn't be incurring seek time as you might with sequential reads?=20

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Marquez, Chris
Sent: Thursday, June 16, 2005 7:53 AM
To: mgogala@xxxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Tim Gorman's "...Cost-Based Optimizer.doc"

One comment / question on OPTIMIZER_INDEX_COST_ADJ;
It seems that on "NON-cached" filesystems (e.g. RAW, OCFS) that there
would/do NOT be a great difference in "db file scattered reads" vs. "db
file sequential reads" every read from disk (on
non-cached filesystem) is a *real* read from OS buffer to
help, no?


Chris Marquez
Oracle DBA


Other related posts: