SQL with 'VIEW PUSHED PREDICATE' in 12.2 Causing Performance Issue
(Doc ID 2641737.1)
Last updated on MAY 12, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
- 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
Changes
NA
Cause
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 |
Changes |
Cause |
Solution |