Re: 4 disks. Best utilization?

Dana Stockler wrote:
>
> Each computer will have 4 disks. What would be the best
> placement
> of the tablespace datafiles and the redo log files on these 4 disks?
>
> Each database will consist of the following tablespaces:
> SYSTEM, <rollback segments>, <our tables>, <our indexes>, <temporary>.
>

create tablespaces accross 3 disks, the fourth disk is used to store archive log files
if you want to make your system recoverable. For better performance, index tablespaces and table tablespaces should be put into
different disks.

For more fine tuning the performance, tablespace layout will be dependent on your application
you will installed.

> -----------------------------------------------------
>

Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Oracle DBA & Unix Administrator      Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049