RE: db_file_multiblock_read_count causing full scans to takelonger?
- From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Dec 2006 12:48:46 -0800
This is implemented at the port level. At least up until 8i
there was a compile time #define value that established the
max I/O transfer size. You could set dfmbrc to any large value
you wanted but it was trimmed to fit within this compile time
limit. I really doubt it has changed since then.
>>>-----Original Message-----
>>>From: oracle-l-bounce@xxxxxxxxxxxxx
>>>[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Allen, Brandon
>>>Sent: Tuesday, December 19, 2006 12:44 PM
>>>To: kevin.lidh@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
>>>Subject: RE: db_file_multiblock_read_count causing full
>>>scans to takelonger?
>>>
>>>According to the docs, if you set it higher than your OS'
>>>max io size, Oracle will automatically scale it down anyway:
>>>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
