Active Data Guard (ADG) RESULT_CACHE Query Hint Not Working On Primary After Switchover
Last updated on JULY 18, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms