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 14:23:40 -0800
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD001C33831@ex2.ms.polyserve.com>

 

>>>
>>>I'm currently on VXFS. My SA is hot for ASM, I haven't had
>>>a chance to do even the smallest bit of research into it.
>>>Any words of warning wrt I/O improvements or drop-offs?

Well, here we have a topic that should be considered just one of the many reasons to use Direct I/O on all filesystems. ASM is raw disk so you certainly wont have **this** problem--if it is indeed read-ahead oriented.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 19 2006 - 16:23:40 CST

Original text of this message

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