SQL Query Running Very Slow and using RULE BASED OPTIMIZER after the snapshot standby switchover
(Doc ID 2735998.1)
Last updated on JANUARY 15, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 to 21.1 [Release 12.2 to 20.0]
Information in this document applies to any platform.
Symptoms
- One of the SQL queries is using RULE BASED OPTIMIZER after migrating to the latest 12.2 RU
- This occurs after the snapshot standby after the switchover
Changes
Updated the database home(12.2) to patch level 201020
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.