Re: Want to BAARF - Recommendations for 10 36G Drive config
Hi Ron, It's done. You're Party member # 42 - with a special obligation to know the Answer to RAID-5, of course. Three members have socalled red numbers that will remain guaranteed constant for as long as we can keep them constant. They are: Carel-Jan Engels (#11) Leif Knudsen (#13) and now Ron (#42). By the way, Peter Gram has now registered BAARF.com and it should be available in a couple of days. In the beginning it will just point to the MiracleAS.dk page for BAARF stuff, but who knows what can happen? Mogens Ron Thomas wrote: Mogens- Can you register me with id 42? It is my age (in a few weeks) and of course the meaning of life, the universe, and everything. Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: Re: Want to BAARF - Recommendations for 10 36G Drive config 06/14/2003 12:59 AM Please respond to ORACLE-L David - I just registered you as Party member # 30. You obviously have the right attitudes :-). Mogens Dave Phillips wrote: 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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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).
Re: Want to BAARF - Recommendations for 10 36G Drive config
Mogens- Can you register me with id 42? It is my age (in a few weeks) and of course the meaning of life, the universe, and everything. Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: Re: Want to BAARF - Recommendations for 10 36G Drive config 06/14/2003 12:59 AM Please respond to ORACLE-L David - I just registered you as Party member # 30. You obviously have the right attitudes :-). Mogens Dave Phillips wrote: >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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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: Ron Thomas 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).
Re: Want to BAARF - Recommendations for 10 36G Drive config
David - I just registered you as Party member # 30. You obviously have the right attitudes :-). Mogens Dave Phillips wrote: 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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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).
RE: Want to BAARF - Recommendations for 10 36G Drive config
>At which point you will no doubt discover that your IO capacity was fine >and it was the damn data that was the issue. That can be simply resolved by certain truncate commands. :) > -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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji 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).
RE: Want to BAARF - Recommendations for 10 36G Drive config
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).
RE: Want to BAARF - Recommendations for 10 36G Drive config
Put SQL Server files on RAID5, Oracle files on the good stuff. Then stand around and say "Well gosh, I guess that SQL Server is just crappy and slow." > -Original Message- > So, any recommendations from the BAARF committee are welcome. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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).
RE: Want to BAARF - Recommendations for 10 36G Drive config
With the limited number of drives, that you have, I'd at least: - move RBS from Raid5 onto first Raid1 (with OA and Oracle); - move redo from Raid5 onto second Raid1; - move Index TS back onto Raid5 Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Dave Phillips Sent: 13. júna 2003 10:26 To: Multiple recipients of list ORACLE-L 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: Igor Neyman 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).