Exadata: Incomplete DST Upgrade will Disable Smart Scan
(Doc ID 2832251.1)
Last updated on MAY 19, 2022
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199.0 [Release 11.2 to 19]
Information in this document applies to any platform.
During a database upgrade, the DST upgrade portion failed. Afterwards, queries are no longer using smart scan in the newly upgraded database, which adversely affects query performance.
If you check the status of the DST upgrade, it does not show as NONE:
Database upgrade, which included DST upgrade, or standalone DST upgrade was run; DST upgrade is incomplete.
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