What is the difference between raid 5 and raid 10? Which is better for oracle?
- 1 Answers
- 689 Views
- I also Faced
- E-Mail Answers
Answer / Pankaj Kumar Gupta
RAID 5 (striped with parity) distributes data and parity information across multiple disks to provide fault tolerance. RAID 10 (stripe of mirrors) combines RAID 0 and RAID 1 by creating multiple RAID 1 sets, striping them together. For Oracle databases, RAID 10 is generally a better choice due to its increased performance and superior write-intensive capabilities.
| Is This Answer Correct ? | 0 Yes | 0 No |
What do you understand by the oracle?
What skills do you need to be a database administrator?
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
How do you install statspack?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
What is dump destination? What are bdump, cdump and udump?
What is pct free/pct used/pct increase parameter in segment?
What do you understand by a control file?
What causes the "snapshot too old" error? How can this be prevented or mitigated?
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
Oracle General 
