Does anyone know of a reference document that recommends how to distribute Oracle database datafiles and online redo logs on an IBM XIV Storage System?
One month ago we upgraded our largest Oracle Server Enterprise Edition 10gR2 database to 11gR2 (11.2.0.3.7). That was the last of our 10gR2 databases to be upgraded to 11gR2. We changed our operating system from AIX 5.2 to AIX 7.1. We also changed from RAID-5 arrays to an IBM XIV Storage System. I was told that XIV would run so fast that we did not need to separate datafiles and online redo logs the way we had on the RAID-5 arrays, so they are all in one large file system. Since the upgrade to 11gR2 we are experiencing longer waits in categories "log file sync" and "log file parallel write". I am guessing the waits have to do with the online redo logs and datafiles being in the same file system, but I am not sure that is the cause. I created an SR with Oracle Support asking how best to arrange files on XIV, and about a memory issue. The memory issue seems to be related to a known bug, for which I will apply a patch. I have not received a reply to my question about XIV. I have asked about XIV three times in the SR. Any help from someone with experience with Oracle database server 11gR2 on XIV would be appreciated.
Thanks,
Bill