SQL with 'VIEW PUSHED PREDICATE' in 12.2 Causing Performance Issue
(Doc ID 2641737.1)
Last updated on JANUARY 29, 2021
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
- Couple of insert with SELECT statements get stuck after database has been upgraded from 22.214.171.124 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