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: ASM IO distribution on a SAN

Re: ASM IO distribution on a SAN

From: LS Cheng <exriscer_at_gmail.com>
Date: Thu, 13 Sep 2007 08:29:35 +0200
Message-ID: <6e9345580709122329t70345b5dq18fe54a08dad5ef4@mail.gmail.com>


You might test disabling SAN read cache but enabling write cache to get a better performance

Thanks

--
LSC



On 9/13/07, ryan_gaffuri_at_comcast.net <ryan_gaffuri_at_comcast.net> wrote:

>
> The Oracle docs state that ASM can perform striping and mirroring. If I
> use ASM on a SAN how is it able to stripe? All it will see are mount points?
> My understanding is that it is possible create LUN(logical Units) and map
> them to individual disks or sets of disks and then possibly map those to
> mount points. Would this make it easier for ASM to handle IO distribution?
>
> The project I am working will fully deploy with 5 billion inserts(all bulk
> loads using external tables) and have 4 million OLTP type queries/day
> (average query returns over 100 rows, but they are all index scans and the
> queries are not that complex). No updates or deletes.
>
> I am trying to find ways to optimize our physical IO. We are using RAC so
> if I need more CPU we can add nodes.
>
-- http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 13 2007 - 01:29:35 CDT

Original text of this message

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