Sun Storedge 3310: 8 disks - How would you configure that ?

I have a sun storedge 3310 SCSI RAID array with 8 36 Gb disks. I want to use that storage for a small database (Approx 8 Gb)

I'm on solaris 9

The database will be in archivelog mode, it is used by web applications. There will be a couple (maybe 10-20) of "hot tables" that will suffer writes, but most of the app is read intensive (intermedia text). Data is to be loaded in tables at night (truncate + sql*loader) when there will not be heavy use of the web application.

This needs to be available 24/24 7/7. I have computers (app server and db server) that have redundant components (mirrored system disks through disksuite/SVM, power supplies)

I'm planning to use the DB server's [mirrored] system disk to store the oracle software and the archived redo logs, I will also put there my hot backups before they are dumped to disk.

I would like to have suggestions about how I should layout my eight 36 gb disk in the 3310 in order to get decent performance. I was planning to use raid 0+1, but I fear I don't have enough spindles. I'm mostly concerned about redo logs, I can't seem to find a way to isolate them.

The 3310 is a HW based raid unit, I have 2 redundant controlers with 512 Mb cache each (But one is the backup of the other, so don't actually have 1Gb cache !)

Thanks a LOT ! Received on Fri Nov 21 2003 - 08:40:35 CST