I figure you have disks set out so Drive 1 + Drive 2 = OS Drive 2 + Drive 3 = Two tablespaces Drive 4 + 5 + 6 = Oracle Default Tablespaces.
And you have bought 4 more disks. I "theorize", like test this to infinity and beyond, that changing this to the following will improve IO performance. Drive 1 + Drive 2 = OS Drive 3 + Drive 4 = swap + archive logs Drive 5 + Drive 6 (mirroring) Drive 7 + Drive 8 = oracle data files. Drive 9 + Drive 10 = redo logs. I.E. stick your data on raid 10,stick redo and archive on two separate mirror sets and separate swap from os. At which point you will no doubt discover that your IO capacity was fine and it was the damn data that was the issue. Niall > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Dave Phillips > Sent: 13 June 2003 16:26 > To: Multiple recipients of list ORACLE-L > Subject: Want to BAARF - Recommendations for 10 36G Drive config > > > A client runs our app with the following layout. Since their > intial 6 drive config they have procured more drives for a > total of 10 36Gig Drives. They have also upgraded memory from > 1 to 4 gig. I have the opportunity to recommend changes to > the current structure to improve performance. > So, any recommendations from the BAARF committee are welcome. > > Current System > > Ora 8.1.7 > Win 2k > Size 30Gig > Logical Array 1 - Raid 1 - OS and Oracle > Logical Array 2 - Raid 1 - App and Index TS > Logical Array 3 - Raid 5 - The rest (Data,Rbs,redo,etc) > > > > > David Phillips > Support DBA > BAARF member wanna-be > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Dave Phillips > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
