Concurrent SQL Statements Run Slower in 12c When Compared to 11g
(Doc ID 2097729.1)
Last updated on MARCH 18, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
- Performance of the concurrent SQL statements degrade after an upgrade to database version 12c.
- The same concurrent SQL statements executed optimally with an expected response time in the 11g environment prior to the upgrade.
- The execution plan for the concurrent SQL statements changed after the upgrade to 12c.
- Setting the OPTIMIZER_FEATURES_ENABLE parameter to 11.2.0.3 or 11.2.0.4 results in a good plan and expected response time.
- Issue is related to Adaptive Query Optimization features.
<Document 2031605.1> - Adaptive Query Optimization
Changes
Database upgrade from 11g to 12c using the default 12c database configuration settings for optimizer related parameters.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |