My Oracle Support Banner

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 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.