Re: Two Drive Oracle Installation?

Anonymous wrote:
>
 

> Generally it is considered more effecient ( one of the primary steps in
> tuning) to place indexes and table data on different disks.
> I notice that you have placed both on the same disk. Any particular reason
> for this ?
 

> ==========MasterG, 12/12/95==========
> I have a two drive Oracle installation and divided the workload as follows:
> control file 1, control file 3, rollback segments, redo logs on drive one
> user data and indexes on disk two. System files on the system disk
> (including swap file).

This actually sounds like a three drive installation. In which case, I thought the three control files should be split up one for each disk, and the redo logs handled in a similar manner. Agreed, the user data and indexes should be split to different disks.

I started this thread a while ago, but I haven't seen an answer. I only have two drives *total*, which includes the system disk. I can't get another disk. Where should I put my files?

Matthew M. Lih
Software Lead, SAIN Project
TRW Data Technologies Division Received on Thu Dec 14 1995 - 00:00:00 CET