Re: 4 disks. Best utilization?

Dana Stockler wrote:
>
> Soon we will be receiving two new computers to be used as Oracle
> database
> servers. Each computer will have 4 disks. What would be the best
> placement
> of the tablespace datafiles and the redo log files on these 4 disks?
>
> Each database will consist of the following tablespaces:
> SYSTEM, <rollback segments>, <our tables>, <our indexes>, <temporary>.
>
> Any and all input will be welcomed.
>
> Regards,
>
> -----------------------------------------------------
> Dana Stockler
> -------------
> Home: Solstadlia 10, 1364 Hvalstad, Norway
> Work: IngeniørData as, Strøket 9, 1370 Asker, Norway
> Email: stockler_at_ingdata.no
> Phone: (+47) 66 78 97 41
> -----------------------------------------------------

Dana,
you need to tell us more:
How big is each disk?
Are the disks on separate controllers?
How big will each tablespace be?
How many users?
What type of application?
also, what is the importance of down time? (you don't really have a enough disks for a failure-proof system).

-- 
+---------------------------------------------------------------+
| Peter Wales                                                   |
| IT Operational Services                                       |
| HP Bulmer Ltd            "The Worlds Largest Cider Maker"     |
| MailTo:PAW_at_bulmer.com          http://www.bulmer.com          |
+---------------------------------------------------------------+