My Oracle Support Banner

Installing and Using Standby Statspack (Doc ID 454848.1)

Last updated on JUNE 12, 2023

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database - Enterprise Edition - Version to [Release 11.1 to 12.2]
Information in this document applies to any platform.


Statspack/AWR cannot be executed on a standby due to its read-only nature. Therefore tuning the performance of the apply process involves manually collecting statistics.

In 11gR1, using the new Active Data Guard option, users can now use statspack from the primary database to collect data from a standby database that is opened read-only and performing recovery.  The standby statspack is installed in a separate schema on the Primary database, STDBYPERF which is then propagated to the standby. This new user does not have DBA privileges and has no access to local V$ tables.


This document applies from 11gR1,

starting from 12.2  ORACLE added Automatic Workload Repository (AWR) support for Oracle Active Data Guard standby databases



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.