24
Jul
06

Installing Oracle using what RAID system?

I realise it is vastly unknown what RAID system must be used to work with Oracle.

Actually the answer is: It depends.

But to answer it there’s just a simple question to ask:

Will my Oracle database write a lot on the disks or read a lot?

How to know?

1) The use of the database (Is it datawarehouse (READ) or some invoice keying (WRITE)?).

2) The frequency of backups.

3) Consider the amount of users.

If it is something involving a lot of keying then it’s best to use a RAID1 or RAID1+0. Some simple mirroring would greatly improve the performance of the server.

If it is a datawarehouse type application where the data are pushed on the server once everyday and then it’s only SELECT statements all day long then RAID5 might do. But the process to push your data in the datawarehouse might take little longer as a consequence.

If you are considering RAID5 anyway, think about this:

1) Use a minimum of 5 disks on your server

2) Enable your writing cache (make sure it’s battery backed cache)

In the case you already use RAID5 with some keying applications, and there’s only a few users, then don’t forget your backups, your tape device. All these are very ressource consuming. At those times where you do backups, the users might feel the server very slow.

To summarize:

Not Datawarehouse> Use RAID1 or RAID1+0 Datawarehouse> Use RAID5 with a very minimum of 5 disks.

Advertisements

0 Responses to “Installing Oracle using what RAID system?”



  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: