Higher CPU and Slow Performance after Migration to 12c with Top Sql as SELECT DEFAULT$ FROM COL$ WHERE ROWID=:1 (SQL_ID: 47r1y8yn34jmj)
Last updated on APRIL 08, 2017
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
- Higher CPU and slow performance after migrating to 12c
- Application is not using bind variable and queries are using literals
- High number of parse and executions of the following recursive queries are seen in the AWR:
Upgraded to 12c from 11g.
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