- Make sure that your system statistics reasonably represent the
operational characteristics of your system. For example, if your system
really averages 3.7 blocks per multi-block read, then CBO will make dumb
decisions about whether to do full-table scans on systems were
db_file_multiblock_read_count=128.
[Naveen Nahata] Can you please elaborate on how I can find, how many blocks
my system reads on an average per oracle multi-block read request?
Regards
Naveen
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 - 00:30:10 CDT
