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

Home -> Community -> Mailing Lists -> Oracle-L -> ASM IO distribution on a SAN

ASM IO distribution on a SAN

From: <ryan_gaffuri_at_comcast.net>
Date: Thu, 13 Sep 2007 02:55:46 +0000
Message-Id: <091320070255.28815.46E8A6B20009A4D00000708F2207021573079D9A00000E09A1020E979D@comcast.net>


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 Wed Sep 12 2007 - 21:55:46 CDT

Original text of this message

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