If you can afford it, and you are using SUN disk. MIRROR/Strip it all. The
Oracle app code, go ahead and use raid 5.
P.S. You really should protect your temp. For one, you will want the
additional performance, but 2 you really don't want your instance to crash
if you can avoid it.
--
Robert Fazio
Senior Technical Analyst
dbabob_at_yahoo.com
"Cristian S." <cs277_at_columbia.edu> wrote in message
news:537e2d08.0107121359.1d18ebc1_at_posting.google.com...
> Hi,
>
> I have this application using Oracle 8i on solaris 8. The database is
> an OLTP type with read/write ratio of 75/25.
>
> We just got a disk array with 12 x 9 GB drives where we want to move
> the database and I want to make sure we set it up right from the
> start. We have one oracle instance with one tablespace where all the
> action is. The disk array is only used by this application so space
> is not a concern (raid 0+1 or 1 are preffered to raid 5).
>
> Below is my proposed setup for the drives. Please let me know if
> something must be changed.
>
> Disks 1-4: RAID 0+1: datafiles, rollback segments, control files
>
> Disks 5-6: RAID 1: redo logs
>
> Disks 7-8: RAID 1: system and index tablespaces, archive logs, backups
>
> Disks 9-10: RAID 1: application code for oracle
>
> Disk 11: No RAID: TEMP tablespace
>
> Disk 12: Hot spare
>
> Thanks.
Received on Sat Jul 21 2001 - 16:35:38 CDT
