High CPU During Parse of Huge SQL with kkqtutlTravOptAndReplaceOJNNCols
(Doc ID 2127439.1)
Last updated on FEBRUARY 19, 2019
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 11.2 to 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.
- 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 to18.104.22.168 may cause the issue. However, this may be also seen in 22.214.171.124.
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