[OAUGNetDBA]-Re: Oracle Apps storage solutions

["James Morrow" <morrow.james@gmail.com>]

I tend towards Hardware RAID over Software RAID (although, that
doesn't tend to make
as big of a deal if you're doing RAID0/1, or 1+0... it's more of an
issue with RAID-5).

Cache size, I tend towards "bigger is better".  Cache is important in
all cases, but,
*especially* if you're doing RAID-5. (Cache can help offset some of
the write penalties
of RAID5, but you have to make certain that you NEVER saturate that
cache... This
is why most people doing architecture won't recommend RAID-5 for
production systems.)

Common RAID levels, in order of my preference for production systems:
     RAID 1+0  Striping across mirrors
     RAID 0+1 Mirrored Stripes
     RAID 1 Mirrors
     RAID 5 Striping with rotating parity

(While RAID 1+0 and 0+1 may appear the same, the difference is really
in how they
handle the SECOND failure... which is why 1+0 or "10" is preferred.)

-- James
----------------------------------------------------------------------
James J. Morrow | Senior Oracle Applications DBA
morrow.james <at> gmail <dot> com




On Tue, Aug 26, 2008 at 2:36 PM, ISS Apps DBA <dba@us.issworld.com> 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>