SQL Profile on an Active Data Guard Standby is not the same as on the primary database (Doc ID 1264838.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 29-JUN-2012***

Symptoms

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.

Cause

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