Re: performance question

Johan den Boer wrote:
>
> Hello Oracle Users,
>
> I have a question about performance. What is the best way to setup
> the oracle database ?
> Suppose you have a database with archiving. Do you seperate the data
> from the archive on seperate disks ? Do you seperate the database
> data from the OS software and application software to get better
> perfromance ?
> How about mirroring the database ? Does anyone has experience with
> mirroring databases on seperated disk/filesystems.
>
> Hope you can help me.
>
> regards
>
> Johan den Boer
> email : jj.den.boer_at_hccnet.nl

There is a lot of talk about...but it really depends on your budget...

In a perfect world, just about every component in a db would be on a separate disk and separate controller with various mirroring and raid options employed...

Some basic advice would be separate as much as possible with preference probably going to the redo logs (warehouses possibly excepted)...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse