RE: optimal set up of tablespaces on disks??

From: <JayMiller_at_TDWaterhouse.com>
Date: Thu, 17 Apr 2003 11:26:51 -0800
Message-ID: <F001.00584367.20030417112651@fatcity.com>

Sorry for the late reply but I'm getting caught up on the list today.

One thing we do that reduces disks required for redo is put a set of redo logs on the same disk as the executables (since these are almost never written to). We also put them on the outside of that disk to maximize performance.

Regards,
Jay Miller

-----Original Message-----
Sent: Saturday, March 29, 2003 12:14 PM
To: Multiple recipients of list ORACLE-L

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: JayMiller_at_TDWaterhouse.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 Thu Apr 17 2003 - 14:26:51 CDT