10-09-2008 03:19 PM
Hi,
Configuration:
Solaris 9
Oracle 9.2.0.8
Sun V890
Two Node Cluster
Veritas Storage Foundation HA for Oracle 5.0 MP1
VXVM, VCS , VXFS with Q/IO enabled
02-15-2009 02:24 PM
02-16-2009 12:28 AM
Hello.
It looks like expected behavior. Here is some assumptions.
Veritas ODM gives to you "like row device performance" with all negatives and positives.
I think your DB is read aggressive, not write (OLAP?).
I think if you will look to yours statspacks you will see significant improvement in write operations. But, I think, your read operations become worse with ODM.
So than you DB works with out of veritas ODM you heavily use file system cache and it helps a lot with read operations. But than you enable veritas ODM you read directly from disk, with out of this case, so service time and amount of read operations go up.
For this type of load ODM isn't the best choice. It can be enabled and be useful, but after rather big DB enhancements.