| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re : 4 disks.......
That's what I thought, splitting data and indexes.
But, for better performance, application engineer recommends to locate both
table and indexes accross 4 disks, because table scans and index look-ups
are done separetely. What do you think ?
Aldi
Oracle DBA
>From: David Barbour <DBarbour_at_connectsouth.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: 4 disks......
>Date: Tue, 18 Jul 2000 11:06:07 -0800
>
>If you have two controllers - use two for data and two for indexes. What
>about your binaries, redo logs and archive logs? Do you have sufficient
>space to RAID1 the data and indexes? If not, despite the performance
>issues, you may be better off going with RAID5 for the availability.
>
>David A. Barbour
>Oracle DBA - ConnectSouth
>512-681-9438
>dbarbour_at_connectsouth.com
>
>
>-----Original Message-----
>Sent: Tuesday, July 18, 2000 11:26 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi list,
>
>If you have 4 disks which one do you prefer :
>
>- use all disks for tables and indexes (and what kind of disk configuration
>: striped, concatenated or raid5)
>- use 2 disks for data and 2 disks for indexes
>
>Thanks for any clue.
>
>Aldi
>Oracle DBA
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>--
>Author: Aldi Barco
> INET: ipal_at_hotmail.com
>
>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).
>--
>Author: David Barbour
> INET: DBarbour_at_connectsouth.com
>
>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).
 |
 |