Measuring Disk I/O
Do you know how your disk subsystem actually is performing?
I have just posted an article on www.thecheapdba.com that will take a look at extracting some I/O statistics so that you can monitor and determine just how well your disks are doing within Oracle.
How can I separate Oracle I/O to maximize performance?
Should I separate data files from index files?
Should I separate redo logs”
These question(s), AND many more, seem to flood our minds as database administrators. They are easy to answer with generalities but in practice can be very difficult to come to a conclusion on unless we take a look at how our disk subsystem is actually performing.
Take a look at this article for some guidance : Measuring Disk I/O