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