How to utilize RAID set?

 We are are expanding our Compaq Server, mostly in the
form of more disk drives. The DB files are yet to be installed,
so we are willing to to do most anything. We will be running Oracle Server
7.3xx & right now we have it in a RAID 5 set, along with
NT. Question: should we put NT on its own physical drive & Oracle
on everything else? What about RAIDing the "Oracle" partition,
which will comprise six 4.3 GB drives?

Ans:

We went through a similar thing as part on an ERP implementation.

I can't say enough about the Oracle DBA Handbook, 7.3 edition, by Kevin
Loney.  The chapter on physical database layout will answer these questions
very well.

Briefly, it comes down to balancing the reads and writes from the various
files (data, index, rollback, temp, system, etc.).  In a RAID 5 you will
have multiple reads/writes to every disk for every request.  While providing
good redundancy performance may suffer with RAID 5.  You need to determine
which files are busiest, and separate them.
 
 

Hosted by www.Geocities.ws

1