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