Re: optimal set up of tablespaces on disks??
Thank you Jared!! Mine is OLTP, I need to more room for Data/indexes. I had that book, May be I need to refer again to understand more. Thanks again. From: Jared Still <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: optimal set up of tablespaces on disks?? Date: Fri, 28 Mar 2003 19:23:37 -0800 It depends: for maximum IO on redo, with mirrored redo logs: 4 2 x 36 RAID 1 for redo 1 2 x 36 for archive logs 1 2 x 36 for executables 2 8 x 36 RAID 10 for data/indexes ( about 250 gig usable ) If you choose not to let oracle mirror the redo logs, you could take four of those drives and add: 1 4 x 36 RAID 10. It really depends on your requirements. Do you need more room for data? Is this OLTP, DW, Hybrid? Anyway, this is a starting point. You would be wise to purchase and study 'Oracle Performance Tuning 101', available at an Amazon.com near you. Jared On Friday 28 March 2003 15:43, Peter R wrote: > Hi Friends, > > Again I need help from you guys! I have 28 x 36.4Gb mirrored disks on AIX > 5L, Would you guys suggest best way of arranging tablespaces across disks!! > I have tablespaces like rbs,temp,tools,index,data etc. > expecting with RAID > > 2 x 36.4 gb RAID-I > 26 x 36.4 gb RAID -I + 0 > > Any ideas will greately appreciated. > peter. > > > > > > _ > Help STOP SPAM with the new MSN 8 and get 2 months FREE* > http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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). _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter R 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: optimal set up of tablespaces on disks??
It depends: for maximum IO on redo, with mirrored redo logs: 4 2 x 36 RAID 1 for redo 1 2 x 36 for archive logs 1 2 x 36 for executables 2 8 x 36 RAID 10 for data/indexes ( about 250 gig usable ) If you choose not to let oracle mirror the redo logs, you could take four of those drives and add: 1 4 x 36 RAID 10. It really depends on your requirements. Do you need more room for data? Is this OLTP, DW, Hybrid? Anyway, this is a starting point. You would be wise to purchase and study 'Oracle Performance Tuning 101', available at an Amazon.com near you. Jared On Friday 28 March 2003 15:43, Peter R wrote: > Hi Friends, > > Again I need help from you guys! I have 28 x 36.4Gb mirrored disks on AIX > 5L, Would you guys suggest best way of arranging tablespaces across disks!! > I have tablespaces like rbs,temp,tools,index,data etc. > expecting with RAID > > 2 x 36.4 gb RAID-I > 26 x 36.4 gb RAID -I + 0 > > Any ideas will greately appreciated. > peter. > > > > > > _ > Help STOP SPAM with the new MSN 8 and get 2 months FREE* > http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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).
optimal set up of tablespaces on disks??
Hi Friends, Again I need help from you guys! I have 28 x 36.4Gb mirrored disks on AIX 5L, Would you guys suggest best way of arranging tablespaces across disks!! I have tablespaces like rbs,temp,tools,index,data etc. expecting with RAID 2 x 36.4 gb RAID-I 26 x 36.4 gb RAID -I + 0 Any ideas will greately appreciated. peter. _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter R 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).
