Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is there any advantage in using Oracle partitioning with RAID 5?

April 26, 2017advantage Oracle partitioning raid

0

Posted

Is there any advantage in using Oracle partitioning with RAID 5?

1 Answer

0

Posted

Partitioning and RAID 5 are two independent and different concepts. Partitioning (spliting a large table or index into subsets) is typically done for either manageability or availability reasons. For example, you can put each partition on a different physical disk, so if a disk fails you lose only one partition. RAID 5 can be implemented in hardware or software to protect data from media or a disk failure. In a RAID 5 disk group, parity data is calculated and spread arcoss all the drives. In case of media or a disk failure, the RAID 5 group can still function in degraded mode based on the parity information. RAID 5 is good for read intensive, but not write intensive applications. There’s no problem mixing partitioning and RAID 5.