After upgrading to Oracle 12c the database server has high CPU usage.
There is a new feature in Oracle 12c called Adaptive Query Optimization that will in most cases make the Oracle database perform better and is enabled by default. However due to the high number of small queries that have be parsed by this new feature it ends up adding a lot of overhead causing high CPU usage on the Oracle database server.
To disable the feature run the following:
alter system set optimizer_adaptive_features=FALSE scope = both;
alter system set optimizer_adaptive_reporting_only=TRUE scope = both;
The information in this article has been included in our product documentation. You can find further details here: