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 15:47:54 -0800
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD001C33839@ex2.ms.polyserve.com>


>>>at that point, but I would expect the difference to occur at
>>>257k, not 256k - and I wouldn't expect it to be such a big
>>>difference. You'd think HPUX could split up the larger read
>>>requests into 255k chunks a little more efficiently than that.
>>>I'll check on a couple more AIX and HPUX systems and see if
>>>they exhibit the same behavior too.

Again, are we talking FS or Direct I/O with these cases where greater than 255KB seems to cause big problems?

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 19 2006 - 17:47:54 CST

Original text of this message

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