Query Regression After Upgraded Database To 12c Due to 'VIEW PUSHED PREDICATES'
(Doc ID 2445377.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.2.0.1 [Release 12.1 to 12.2]Information in this document applies to any platform.
Symptoms
- Query regression after upgraded database to 12.1 and 12.2 from 11204
-
Due to 'VIEW PUSHED PREDICATES' leads to bad cost and execution:
VIEW PUSHED PREDICATE VW_11 (cr=31214568 pr=31111082 pw=0 time=334206484 us starts=12937 cost=396 size=9 card=1) <<<<<<<<
Changes
Database Upgrade
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 |
References |