High CPU During Parse of Huge SQL with kkqtutlTravOptAndReplaceOJNNCols
(Doc ID 2127439.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.2 to 12.1]
Information in this document applies to any platform.
- Parse of huge SQL incurs high CPU and hangs for long time
- The problem SQL is pretty huge with many nested views involved
- Changing optimizer_features_enable to old versions like 10.2.0.5 does not help
- Generating errorstack shows following stack of the process:
Call stack of the process running SQL shows the following:
Upgrading the database from earlier versions to188.8.131.52 may cause the issue. However, this may be also seen in 184.108.40.206.
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