High CPU Parse Time On 12c On Complex Queries Which Uses Materialized With Subquery

(Doc ID 2233036.1)

Last updated on FEBRUARY 15, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Very high hard parse time on 12.1.0.2.0 for complex SQL over 35 sec comparing to 3 seconds in Oracle 11.2.0.4
They query uses complex materialized with subquery

Upgrade to 12.1.0.2 from 11.2.0.4.

	Sign In with your My Oracle Support account
	Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms