Re: How to spread oracle installation on 2 HD

From: Phineas T. Barnham <PhineasTBarnham_at_DONTSPAMME.opcomp.demon.co.uk>
Date: Sat, 5 May 2001 08:29:31 +0100
Message-ID: <989048069.18896.0.nnrp-08.9e985e86@news.demon.co.uk>

"Christian Greven" <greven.christian_at_baufeldt.de> wrote in message news:9cu6r1$vju$04$1_at_news.t-online.com...
> Hi,
>
> what is the best spreading of an oracle db using two single hard disks?
> It's no production system, only for testing. But it should be fast.
> Oracle 8.0.6, Windows NT 4.
>
> One small partition is used for the windows system.
>
> Oracle installation,Data and rollback tablespace on disk 1.
> Indexes, logs on disk 2.
>
> Any suggestions?
>
> Thanks in advance.
>
> Bye,
> Christian.
>

On a 2*disk Windows install, I shouldn't bother trying to place files for performance. I doubt there is much gain that you can make.

If you put all of the frequently used Oracle files on disk 2, then they'll at least be separated from the OS and it's swap file.

Take a look at OFS in the Oracle manuals. Received on Sat May 05 2001 - 02:29:31 CDT