We're migrating to 12c from 11g in a Linux environment. Everything is okay except for one small annoyance that is going to drive our developer crazy if I don't get it fixed. And that problem is that accessing tables has gone from 3 seconds on average to almost 30 seconds in some cases. This is causing Tomcat 8 to take up to 6 minutes to start, whereas it used to take less than half that time.
I can open a table in Navicat (for example) on our 11g instance and it's quick as lightening. I open the same table from the 12c database and it's at least 15 seconds...usually closer to 20.
The environment for the old 11g database is a Centos 64 bit VMware image with 10 gigs of RAM and not using ASM. The new database is Oracle Unbreakable Linux 64 bit VMWare image with 15 gigs of RAM and using ASM. Although I created an instance that doesn't use ASM on that server and the time issue remained.
Thanks for any troubleshooting suggestions.