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: Hard disk configuration for fast write (Insert)

Re: Hard disk configuration for fast write (Insert)

From: Mladen Gogala <mgogala.spam-me-not_at_verizon.net>
Date: Wed, 15 Nov 2006 08:54:18 GMT
Message-ID: <pan.2006.11.15.08.54.19.257623@verizon.net>


On Wed, 15 Nov 2006 01:57:13 +0000, Sam wrote:

> Hi There,
> What is the best Hard disk (Raid or striping) configuration (With minimum
> number of hard disk) for a Oracle database with lot's of
> Insert but not that much of read (query), also this database dos not need to
> be in archive mode (Data is not that critical right now).
>
> Thank you in advance - Sam

For fast I/O, you want to maximize the number of disks and controllers and do striping and mirroring, aka RAID-10. Minimizing the number of disks is not smart, at least not if you need performance.

-- 
http://www.mladen-gogala.com
Received on Wed Nov 15 2006 - 02:54:18 CST

Original text of this message

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