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 <jkstill_at_cybcon.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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: jkstill_at_cybcon.com
>
>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: 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).
>
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: niagarap_at_hotmail.com
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: 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).
Received on Sat Mar 29 2003 - 11:13:37 CST
