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
Oracle Database - Enterprise Edition - Version 220.127.116.11 to 21.1 [Release 12.2 to 20.0]
Information in this document applies to any platform.
- 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
Updated the database home(12.2) to patch level 201020
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.