I am in the middle up upgrading my CA PPM from 14.3 to 15.3. Part of my migration plan is to move from Oracle 11 to Oracle 12. This has become problematic due to poor performance. The big issue that I discovered is that the attributes page for the Project object will not open. I click the tab, and then the application never returns. I have isolated the query in OEM and it continues to run even after the application gives up. It just ran 2 hours before ending.
I am also experiencing poor performance on a few of our custom jobs
I have 2 environments in different stages. Both fail. It appears that the oracle version is causing the problems.
Dev: Oracle 12 & PPM 15.3
QA: Oracle 12 & PPM 14.3
I have matched my db parameters to the CA recommended settings.
I'm hoping this sounds familiar to someone who has solve it in their environment.