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

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