My Oracle Support Banner

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

Last updated on OCTOBER 13, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 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.
***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

To view full details, 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 a vibrant support community of peers and Oracle experts.