[OAUGNetDBA]-Re: Oracle Apps storage solutions

[Mike Charchuk <Mike.Charchuk@telus.net>]

I've used sun A3500, T3s, 9960 (actually a Hitachi), EMC 300, 700, an HP 
Tier1 storage array (another re-badged Hitachi) and I have seen the best 
performance with lots of spindles, the Veritas file system and hardware 
RAID 10 (best) and RAID 5 (ok).   I have no experience with raw 
partitions or asm.

Don't let the sales people con you into using a few large disks.  15,000 
RPM disks and lots of them will give you the best performance.We have 
seen performance degradation moving from old technology (A3500 and T3s) 
but with lots of 10,000 RPM 18 and 36GB Disks to new technology EMC Gear 
with 10,000RPM 73 and 146 GB disks.  Array cache can only do so much.   
We went down at a ratio of 4 to 1 which I think is to much.  I wouldn't 
recommend going down to anymore than half the number of disks you 
currently have.  

Also sharing the storage array with other applications (even if they are 
on different disks) does affect performance so if you can keep the 
storage dedicated to your application it would be best.


ISS Apps DBA wrote:
> We are evaluating storage solutions for our applications 11i instance 
> (about 200GB and growing about 2 GB per month).
>
> Our sales reps are offering an EMC CX4-120 solution.  I have always 
> used Sun arrays (currently A5200) and am not familiar with EMC solutions.
>
> Does anyone have any recommendations/suggestions on what type of 
> storage solutions are better for Oracle (software vs hardware RAID, 
> cache sizes, etc.)?
>
> Sorry if this is very vague, but I am not even sure what questions to 
> ask at this point.
>
> Thanks,
> Chris --------------------------------------------------------
>
>
>
>  
> dba dba - Sanitors -  - dba@us.issworld.com San Antonio Phone: 
> 210-495-6021 Mobile:  Fax:  Web: Address: 1019 Central Parkway North 
> Suite #100, San Antonio, Texas   The information in this e-mail 
> (including any attachment) is confidential and intended to be for the 
> use of the addressee(s) only. If you have received the e-mail by 
> mistake, any disclosure, copy, distribution or use of the contents of 
> the e-mail is prohibited, and you must delete the e-mail from your 
> system. As e-mail can be changed electronically ISS assumes no 
> responsibility for any alteration to this e-mail or its attachments.  
> ISS has taken every reasonable precaution to ensure that any 
> attachment to this e-mail has been swept for virus. However, ISS does 
> not accept any liability for damage sustained as a result of such 
> attachment being virus infected and strongly recommend that you carry 
> out your own virus check before opening any attachment  [v.1.e]
>
> #############################################################
> This message is sent to you because you are subscribed to the mailing 
> list <OAUGNetDBA@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com>
> To switch to the FEED mode, send any message to 
> <OAUGNetDBA-feed@oaug.com>
> To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@oaug.com>
> To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com>
> Send administrative queries to  <OAUGNetDBA-request@oaug.com>


#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNetDBA@oaug.com>.
To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNetDBA-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com>
Send administrative queries to  <OAUGNetDBA-request@oaug.com>