On Friday 03 January 2003 01:16 pm, you wrote: > You still may get better performance with LVM because the I/O architecture > only allows one (1) I/O to a given device address at a time. If you stripe, > then you actually have multiple device addresses assigned to a single file > system, so you can have multiple I/O (one per device address) active to the > filesystem at a time.
Having managed Oracle on Solaris/SPARC in a different life, I'll tell you that the Oracle guru's love the idea of more spindles. You will gain healthy performance increases by mirroring stripe sets (commonly known as RAID 1+0) for the exact reason as is stated above. Now with Oracle it's really only realized when transactional logs and index files are kept on such a volume. We found no substantial increase in performance associated with keeping data and code on striped volumes (at least not enough to justify the cost and maintenance overhead). Little disclaimer, this was Oracle 8i - there might be functional differences in Oracle 9i that change these findings.
