Re: DISK LAYOUT & RAID LEVEL

Hi Harvinder,

If I were you I would

• put OS and Oracle executables on a RAID1 volume with minimal raid block size
• put redo log files in "chess order" on two dedicated RAID1 volumes (the odd redo groups locate on the first volume and the even redo groups locate on the second RAID1 volume). It seems 9Gb disks are more suited for that goal. I'm still not sure what raid block size should be choosen for these volumes. I assume it should be minimal and cover your average redo write size.
• make a RAID1 volume for archive redo logs, let say 2x36 (depends on the volume of your archive logs)

The most difficult decision I think is how to locate your index, data, rbs, temp and what stripe
size to choose. In general it depends on your application. In your case I would prefer to have
several RAID volumes in order to be able to balance disk loading on data and indexes. Levels RAID1+0
or RAID0+1 are more suitable here.

There are several articles at Steve Adams' site www.ixora.com.au and good Gaja's article about RAID
at www.quest.com

I think 25-30% of RAM is a good start point for SGA.

Regards,
Ed

> Hi,
>
> We have to do benchmarks tests(scalability,performance) for our product and
> have machine with following
> configuration..We dont have experience for large size databases layout.
> It will be greatly appreciated if someone points out from his experience:
>
> 1) Which raid level to use for which files and on how many disks.
> 2) As we have 10 disks what file to place on which disk.
> 3) How much RAM to use for SGA.(this is database dedicated machine)
>
> Server - E3500 with 2 internal boot disks (18GB)
> 4 400MHZ/8MB ecache and 2 GB ram
> 2 I/O boards
>
> Arrays - HDS 9210 Fiber channel array with 10 36GB disks @ 10K RPM with
> 5.7 read and 6.5 write seek.
> Sun A5200 with 22 9GB Seagate drives @ 10KRPM with 5.4 read and
> 6.2 write seek.
>
> HDS is a hardware based array and the A5200 is software with Veritas VM
>
> Thanks
> -Harvinder
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Harvinder Singh
> INET: Harvinder.Singh_at_MetraTech.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Edward Shevtsov
  INET: ed_at_mb.ru

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).