Re: Are you good on Performance, Raid and configuration

Sam wrote:
> Hi everybody,
> I need your opinion for a few basic performance and configuration questions,
> I have a database with a mix amount of read and write and I have a new
> computer that support Raid with SCSI hard disk,
> the environment is a development/test environment and redundancy is not
> important right now,(Just performance is important right now)
>
> I just have 2 hard disk available right now, which one give me better
> performance:
> 1. Mirroring
> 2. No Mirror and install OS on first hard disk and Oracle on second hard
> disk
>
> Second questions , How do you place different oracle files: Data Files,
> Index Files, Log Files?
> For example if you select number 2 (No Mirror) on witch hard disk you put
> Data files, index files and so on to get a better performance?
>
> Thanks you in advance - Sam

If all you want is speed and you don't care about redundancy then stripe both disks and let it go where-ever it is going to go.

My suspicion is that the improvement will be close to unmeasurable but given only two disks that is about all you can do.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org