Exadata: Incomplete DST Upgrade will Disable Smart Scan
(Doc ID 2832251.1)
Last updated on OCTOBER 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 19.13.0.0.0 [Release 11.2 to 19]Information in this document applies to any platform.
Symptoms
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:
Changes
Database upgrade, which included DST upgrade, or standalone DST upgrade was run; DST upgrade is incomplete.
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 |