distributing datafiles in server [message #480611] |
Tue, 26 October 2010 01:24 |
ultgnp
Messages: 106 Registered: May 2010 Location: Germany
|
Senior Member |
|
|
Hi,
Could someone please tell me how to distribute the datafiles among various disks of a server, so that I/O operations are improved.
I mean is there any area we need to focus while distributing the disk like:
1)Particular types of datafiles should be placed in one disk.
2)Temp/Undo/Rollback tablespaces in another disk.
3)Indexes in another disk
Is this a right way? Please guide me if i am wrong.
Best Regards,
|
|
|
|
Re: distributing datafiles in server [message #480625 is a reply to message #480613] |
Tue, 26 October 2010 02:44 |
ultgnp
Messages: 106 Registered: May 2010 Location: Germany
|
Senior Member |
|
|
Since data is mission critical, we need higher availablity and Max performance. Which RAID level will be good RAID 5 or RAID (1+0 or 0+1).
Could you also please explain me briefly your statement:
Quote:Stripe everything on all disks (and if you can separate redo logs on other ones).
|
|
|
|
|