Re: Oracle and disk striping

It depends on what you are trying to achieve?..

If you have small, random reads, then no, striping those tables is not a good idea - the overhead of syncing the disks will make things slower.

If you trawl through large amounts of data in a table(s), then striping the data can provide massive improvements in performance. Datawarehouse style apps benefit from this, especially if you use Oracle Parallel Query to keep the CPU up with the striped disk I/O.

Likewise if you perform large sequential writes, striping will give an improvement. For small, random writes, striping won't help.

Think before you act, and test whatever you implement.

Ps. Don't forget that if a disk fails in a stripe set you will have to recover the entire stripe set, which could be quite a lot. So look at setting up multiple, smaller stripe sets of disks, especially for large tables that you regularly join (i.e., get them on different sets/disks).

MotoX.

Marco BANO wrote in message <35F79538.3B97F0A5_at_eumetsat.de>...
>Hi,
>
>Just a general question. It is good put Oracle datafiles on Striping
>disks ?
>
>THANKS
>
Received on Thu Sep 10 1998 - 06:03:20 CDT