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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i tunning

Re: Oracle 9i tunning

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 25 Jun 2002 20:34:18 +0100
Message-ID: <3d18c5bc$0$8509$cc9e4d1f@news.dial.pipex.com>


"Joe" <joegenshlea_at_attbi.com> wrote in message news:pOKR8.165885$6m5.138459_at_rwcrnsc51.ops.asp.att.net...
> Cool! A pleasent, helpful and non-condencending response.
>
> It isn't too late for change RAID - I am still in the system analysis
> portion of my project and am testing different configurations. I am a one
> person shop I have full control! I think RAID 5 works well with SQL server
> because you don't have control of tablespaces and datafiles like you do in
> Oracle. I would like some fault tollarance above restoring backup tapes,
> given this, what do you recommend for disk configuration?
>
> Here is my current situation with hardware:
>
> Dual AMD athlonn MP 2000+
> 2 Gigs DDR Ram
> RAID (PCI) controller that supports 4 devices with 32MB RAM mounted
(Adaptec
> 2400A)
> 6 Western Digital 80 Gig (8MB cache) ATA/100 disks
> Total Flexibility!
>
>
> Anyone is welcome to submit a vote to optimize hardware configuration for
> Oracle!

My vote would be (and it sure aint optimised but the you don't have 70 disks)

2 mirrored drives = os.
2 mirrored drives = redo.
2 drives mirrored =everything else.

If you can persuade them to buy 24 18 gig drives that would be way better.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Tue Jun 25 2002 - 14:34:18 CDT

Original text of this message

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