SQL Profile on an Active Data Guard Standby is not the same as on the primary database
Last updated on JANUARY 27, 2017
Applies to:Oracle Server - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
***Checked for relevance on 29-JUN-2012***
After following best practices for tuning read-only queries that execute on an Active Data Guard standby database, it is observed that the active standby is using different execution plans than those used on the primary database. This conflicts with the fact that an Active Data Guard standby database is an exact replica of the primary database in all regards. It uses the same optimizer statistics generated by its primary database, including system statistics. It also uses the same SQL plan baselines and SQL profiles used by the primary database.
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