DISK LAYOUT & RAID LEVEL

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Fri, 30 Nov 2001 08:00:10 -0800
Message-ID: <F001.003D1EE5.20011130073520@fatcity.com>

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:

Which raid level to use for which files and on how many disks.
As we have 10 disks what file to place on which disk.
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). Received on Fri Nov 30 2001 - 10:00:10 CST