Performance Issue With High CPU Usage After Upgrade to 12c RDBMS
Last updated on MAY 31, 2016
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Exadata X5-2 Full Rack - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.
Performance issue after Database upgraded to 12c.
Customer upgraded from 11g to 12c.
All the queries are taking multifold time after upgrade, compared to previous version. No change in the underlying hardware or any other parameters.
AWR report Analysis:
Increased DB CPU (For example, in a customer case it is 5,374sec to 20,705sec for 1 hour duration)
All other waits are fairly similar.
Number of parses (Hard and Soft) are similar between the 2 versions.
RDBMS upgrade to 184.108.40.206.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms