RE: CBO irregularity
- From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 7 Jun 2004 23:47:34 -0700 (PDT)
> Why wud the no. of blocks read be less than
> DB_FILE_MULTBLOCK_READ_COUNT?
>
> Is it dependent on the I/O sub-system?
a. few blocks may be already in cache
b. hitting the extent boundary or smaller sized extents
c. Hitting the highwaremark
d. SSTMAXIO is less than MBRC
e. Those blocks may be mastered/cached in remote cache
f. any other things I have missed..
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
