So now we know about the hardware, what about the db? How much data, how
many tablespaces, etc.

Mike

-----Original Message-----
From: Harvinder Singh [mailto:Harvinder.[Email Address Removed] Friday, November 30, 2001 10:37 AM
To: LazyDBA.com Discussion
Subject: DISK LAYOUT and Benchmark Tests


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

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page