RE: CBO irregularity
- From: "Naveen, Nahata (IE10)" <Naveen.Nahata@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 7 Jun 2004 22:18:44 -0700
- 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
Other related posts:
