Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sun Storedge 3310: 8 disks - How would you configure that ?
Guy Dallaire wrote:
> 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 !
Given the small size of your database and the amount of disk you have ... keep a disk for archive logs and SAME.
If may not be the perfectly optimal system ... but it will be in the 90% range.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri Nov 21 2003 - 15:39:10 CST