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 126.96.36.199 to 188.8.131.52 [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:ksedsts()+465<-ksdxfstk()+32<-ksdxcb()+1927<-sspuser()+112<-__sighandler()<-kkqtutlReplaceTLOJNNCols()+252<-kkqtutlReplaceTLOJNNCols()+581<-kkqtutlReplaceTLOJNNCols()+581<-kkqtutlReplaceTLOJNNCols()+581
Upgrading the database from earlier versions to184.108.40.206 may cause the issue. However, this may be also seen in 220.127.116.11.
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