RE: Drive Configuration

RAID 5 is basically used for READ type of operations. WRITE operations as = slow as snails. If you use all 5 of the disks as 1 RAID 5 configuration = you will loose the capacity of 1 disk for parity. ex: 5- 20 GIG disks =3D = 80 GIG RAID 5.
Yuor system will be slow and the i/o contention will be out of site. At = least put the system and redo on separate disks and but more disks for = the RAID.
We have SYSTEM and ORA and REDO on separate RAID1 drives and all other on = a RAID 5 drive of 5- 18 GIG drives giving a total of 72 GIG available on = the RAID 5. We experience a 36 % Oracle wait during the data load = procedures each day. After the load is completed the querries are fast. ROR m=AA=BF=AAm

>>> kevin_at_dulcian.com 01/25/01 10:41AM >>>
Hey I like your configuration, but I do hear that RAID 5 (hardware controlled) is pretty awesome. Can't wait to see what all the DBA's say. Kevin

-----Original Message-----
Sent: Thursday, January 25, 2001 10:02 AM To: Multiple recipients of list ORACLE-L

I was asked by some hardware people of my suggested drive configuration = for
a 5 drive configuration.

I recommended the following:

Drive 1 - Oracle database software
Drive 2 - System tablespace, control file_1, online redo log files
Drive 3 - Roll back (RBS) tablespace, Temp tablespace, control file_2
Drive 4 - Data tablespace, control file_3
Drive 5 - Index tablespace, archived log files

I thought this would optimize the performance of small transactions and small queries. I also thought it would optimize I/O performance by distributing the tablespaces. The database is for a Cold Fusion web site where there will be mostly reads but plenty of writes.

They disregarded this configuration and decided to go with a raid-5 with everything on the single raid for recoverability. I caved in and said ok. Were they right?

Sincerely,

Woody

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--
Author: Woody Mckay
  INET: wmckay_at_hydrogenmedia.com=20

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).

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20
Author: Kevin Kostyszyn
  INET: kevin_at_dulcian.com=20

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