After Upgrading to 12.2 from 12.1 Queries Running Badly with 'Index Fast Full Scan'
(Doc ID 2509667.1)
Last updated on NOVEMBER 05, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
- Lot of queries which completed in few seconds in 12.1 version are performing badly in 12.2. The queries does not complete in 12.2.
- The query run completes as earlier when the OFE is set to 12.1
- Difference in Execution Plan is following:
INDEX RANGE SCAN TEST >>>In 12.1 report
INDEX FAST FULL SCAN TEST >>>In 12.2 report
Upgrade the database from 12.1 to 12.2
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