Re: RAID configuration for Oracle7

> Which are the best configuration of datafiles, control file,
> log file e archived log files?
>

    Traditionally, data, indexes, log, rollback, temp and data dictionary files must be on different physical devices (balancing I/O workload on controller cards) for best performance. For control files, to have several copies on different disks is required.

   Under RAID, and specially RAID level 5, this change. First, RAID 5 configuration is intended for data integrity and fault tolerance. Second, RAID is designed to distribute I/O operations on several physical devices. So, if your disk array is where you are goint to put your database, there is no reason to seek for diferente divices for your database files. For the operating system, the disk array is a whole logical device.

   If you are going to use your disk array and other disks to create your database, I suggest put data and data dictionary files on the array . Indexes may be put on an separate disk (they can be reconstructed fron data dictionary on a system crash). I'm not sure where must be temp, rollback and log files. Temp is conditioned by the applications (excesive sorts or index creation may be force you to dedicate and special device to avoid disk contention). Oracle is a RDBMS robust and secure against system failures, so RAID 5 security my be redundant and a cause for I/O contention.

   Remember, Oracle is I/O bounded.

-- 
                                               Saludos...
                                               Best regards...


  Eduardo Rene Rodriguez Avila                             
                                                              
  E-Mail: e.r.rodriguez_at_ieee.org                             _/ _/
          eravila_at_geocities.com                           _/     _/
          eravila_at_spin.com.mx                              _____/
  WWW   : http://spin.com.mx/~eravila
          http://www.geocities.com/CapeCanaveral/8319