Re: Oracle on Digital Unix RAID

From: Sheri7102 <sheri7102_at_aol.com>
Date: 1996/09/15
Message-ID: <51hhfc$iik_at_newsbf02.news.aol.com>#1/1


Oracle would love you to mirror the disks... Reason being that it is easier to lay down tablespaces in different physical disks and split processing so that table, index, and rollback read/writes can occur simultanously. When RAID5 is employed, five disks may mean that you physically store the tablespaces all in the same location, thus making it difficult to split out processing. It also may be difficult to tune with any certainty. But people still do it and have to depending on the hardware available.

Always store rollback and redo/archive on their own physical devices. Table and index tablespaces should also be split on different drives and should be striped with many smaller datafiles across many disks to futher enhance simultanous searches.

An ultimate configuration would employ mirrored small disks (500Mb) each with their own controller Redo, archive, rollback, tables striped, indexes striped on dedicated physical disks. Work you way back from that logic. Just strive to split out processing as much as possible....

The ultimate configuration is one where that employes Received on Sun Sep 15 1996 - 00:00:00 CEST

Original text of this message