Message-ID: <3ADA111D.74125C2E@ntsource.com>
From: Frank Hubeny <fhubeny@ntsource.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle & RAID strategy question
References: <3AD9CD59.A55E27A3@mediaone.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 59
Date: Sun, 15 Apr 2001 14:22:37 -0700
NNTP-Posting-Host: 63.74.180.103
X-Trace: newsfeed.slurp.net 987362282 63.74.180.103 (Sun, 15 Apr 2001 14:18:02 CDT)
NNTP-Posting-Date: Sun, 15 Apr 2001 14:18:02 CDT


You might have a look at Juan Loaiza's article "Optimal Storage
Configuration Made Easy" http://technet.oracle.com/deploy/performance/ for a
different approach to the problem.  Since this is on technet, it appears to
be Oracle's latest recommendation.

I am discussing with a fellow dba whether we should implement Loaiza's
design or not and I would welcome any comments from others who have tried
already.

Frank Hubeny

Kate Kwiatek wrote:

> Greetings....
>
> I have a Sun E450 to configure for some small Oracle databases that will
> reside on the system. The system has 8 36-Gig hard drives and 2
> controllers. For now, the Oracle databases are fairly small and not real
> write-intensive at all. One of the databases is the database for our
> Oracle Portal application and the other database will hold financial
> information for a third-party forecasting and reporting tool called
> Control8 (KCI Computing). I'm not the actual unix sys admin who will be
> configuring the box, but the Oracle DBA driving the general
> configuration request.
>
> My dilemma is that I'm torn between which implementation of software
> RAID i should have the sys admins build. We must have complete
> redundancy so 4 disks will definitely be mirrored -- an unfortunate
> overhead, but my company can afford it. The two choices I have are the
> following:
>
> 4 disks each individually mirrored and manually laying out my Oracle
> directories to separate data, indexes and database software...
>
> or
>
> 2 logical volumes(4 disks-1controller each) striped and mirrored with an
> LVM like Veritas Volume Manager
>
> The problem I have with the second option is that I cannot directly
> control the separation of data and indexes in the Oracle environment,
> but since the databases are small and not highly-transactional, I am
> thinking the disk i/o benefit from the striping alone will negate this
> issue.
>
> Does anyone have any advice on which setup I should go with?? I
> understand the implications of failures for each, so I'm really just
> wondering which would offer better read-write performance for my
> particular database environment.
>
> I appreciate all advice....much thanks to all who reply:)
>
> Sincerely,
>
> Kate Kwiatek
> Manager - Technical Control
> Raytheon Company
> kwiatek@raytheon.com