Re: Distributed files

At a minimum you will want to isolate you RBS, TEMP, REDO logs,SYSTEM, INDEX and DATA tablespaces on separate disks. Contention will be when users are trying to access the same file at the same type so with the extra disks, I would stripe your most frequently used tablespaces and indexes. If this is one very large table and you want to stripe it, be sure that the table is designed to stripe across the files, (create it so that it is one block size bigger than the initial file). This is only for tables that reside in their own tablespace.
There are several good books out there on performance tuning and are some good papers on the Developers Programme site.

-Sheilah Scheurich
DBA

-- 
These opinions are my own and not
not of my employer.



Smith, Gordon <helfrich_at_email.unc.edu> wrote in article
<Pine.A41.3.95.970723004556.96418B-100000_at_login0.isis.unc.edu>...


> Can anyone give me advice on, or tell me where to read about, how to

> distribute Oracle files across disks to optimize throughput and minimize

> contention?.  In our case, we will probably have 7-8 disks on which to

 put


> all of our data files.  These data files include the SYSTEM, TEMP, RBS,

> Redo Logs, Archive Log, Data Tables, Indexs, etc.  Is it simply a matter

> of separating database objects on to different disks if they are being

> used concurrently?  Thanks

> 

> 

> 

> 

> 

> 

> 

>