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 126.96.36.199 and later
Information in this document applies to any platform.
- Couple of insert with SELECT statements get stuck after database has been upgraded from 188.8.131.52 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