Re: Minimal disk configuration for Oracle

In article <4gihj5$ect_at_nytimes.us.wfl.com>, johnny_baker_at_us.wfl.com wrote:
>What are the MINIMAL number of disks guaranteeing point-in-time recoveryy
>and "decent" performance on a database of 1GB or less with 50 active
 concurrent users. These disks will be
>mirrored.
>
>This is what I have now. Can you improved on this?
>
>Disk 1 - Oracle executables
> System tablespace
> Redo log files
> Tools tablespace
> Export dump file
> Copy of control file
>Disk 2 - Data
> Temporary tablespace
> User tablespace
> Copy of control file
>Disk 3 - Indexes
> Copy of control file
>Disk 4 - Rollback segments
> Archived redo log files
>
>Reply to johnny_baker_at_us.wfl.com or direct posting.
>
>Thanks in advance
>
>
>

Hi Johnny

When I took my DBA courses at Oracle, they suggested to me that Optimally configured servers have arrays of 18- 22 disks. Building on what you have drawn out, it would be similar to this:

Disk 1 - Oracle executables

Disk 2 - System tablespace          

Disk 3 - Tools tablespace

Disk 4 - Export dump file

         Copy of control file

Disk 5 - Data          

Disk 6 - Redo log files         

Disk 7 - Temporary tablespace

         User tablespace

Disk 8 - Indexes          

Disk 9 - Rollback segments         

Disk 10 - Archived redo log files

           Copy of control file

Disk 11 - Master Control file

The setup that you described above is close enough to what our instructor described for a minimally configured server. with the exception of redo log files and multiple copies of the control files. You might get a performance hit with disk IO on your Disk 1 setup.

• Andre T. Allen * andre_at_interaccess.com **
• SYSADM/DBA * 74262.3572_at_compuserve.com **
• Reid Psychological Systems * 312.938.9200 (Voice) **
• Chicago, IL * 312.294.0104 (Fax) ** **

  ---