Re: performance question

"Johan den Boer" <jj.den.boer_at_hccnet.nl> wrote in message news:39805C70.51CD4617_at_hccnet.nl...
> Hello Oracle Users,
>
> I have a question about performance. What is the best way to setup
> the oracle database ?

There's an 'optimal' configuration that requires you to use, I think, 22 disks per database! There's a 'compromise' version that requires 12 disks, and you can just about squeeze that down to around 9 if you are prepared to lose a bit of performance.

> Suppose you have a database with archiving. Do you seperate the data
> from the archive on seperate disks ?

The 'standard' recommendation is: keep data away from indexes; keep rollback segements away from everything; ditto with you temp tablespaces; ditto with you online redo logs; there should be an entirely separate disk for archives, and another entirely separate for export dump files. And the whole lot should be kept apart from the Oracle executables and the OS.

Good luck negotiating the budget for all of that!

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

Mirroring isn't going to help performance any: it's a security/reassurance thing. Assuming you've set up a 22-disk optimal implementation of a database, feel free to find the budget for another 22 disks and mirror the whole lot (per database!). It means recovery from disaster will be stupendously easy, probably.

On the other hand, assuming your budget is limited, keep data and indexes separate, find a separate home for your redo logs, and use Oracle features to ensure the redo groups are mirrored, and your control file is at least duplexed.

These sorts of things are always compromises between rivers of cash and adequate performance.

Regards
HJR
> Hope you can help me.
>
> regards
>
> Johan den Boer
> email : jj.den.boer_at_hccnet.nl
Received on Sat Jul 29 2000 - 00:00:00 CDT