Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: db_file_multiblock_read_count causing full scans to takelonger?

RE: db_file_multiblock_read_count causing full scans to takelonger?

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Tue, 19 Dec 2006 12:48:46 -0800
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD001C33829@ex2.ms.polyserve.com>

 

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_at_freelists.org
>>>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Allen, Brandon
>>>Sent: Tuesday, December 19, 2006 12:44 PM
>>>To: kevin.lidh_at_gmail.com; oracle-l_at_freelists.org
>>>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:
>>>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 19 2006 - 14:48:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US