> Why wud the no. of blocks read be less than
> DB_FILE_MULTBLOCK_READ_COUNT?
>
> Is it dependent on the I/O sub-system?
- few blocks may be already in cache
- hitting the extent boundary or smaller sized extents
- Hitting the highwaremark
- SSTMAXIO is less than MBRC
- Those blocks may be mastered/cached in remote cache
- 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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Jun 08 2004 - 01:44:19 CDT
