High CPU During Parse of Huge SQL with kkqtutlTravOptAndReplaceOJNNCols
Last updated on APRIL 20, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [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 to22.214.171.124 may cause the issue. However, this may be also seen in 126.96.36.199.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms