Active Data Guard (ADG) RESULT_CACHE Query Hint Not Working On Primary After Switchover
(Doc ID 2159553.1)
Last updated on MARCH 14, 2019
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Active Data Guard
Queries are not using RESULT_CACHE hint after a primary database in a Data Guard configuration has done a switchover and then been switched back so as to be running on the original host.
Check the explain plan of the query to confirm the same.
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