SQL with 'VIEW PUSH PREDICATE' in 12.2 Causing Performance Issue (Doc ID 2641737.1)

Last updated on MARCH 12, 2020

Applies to:

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

Couple of insert with SELECT statements get stuck after database has been upgraded from 11.2.0.4 to 12.2 version
Checking the Plan is different than 12.1 and in 12.2 the time consumed in VIEW PUSH PREDICATE

	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

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.