Last updated on APRIL 20, 2016
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [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 to18.104.22.168 may cause the issue. However, this may be also seen in 22.214.171.124.
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