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 AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition - Version 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.


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.