My Oracle Support Banner

Installing and Using Standby Statspack (Doc ID 454848.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Purpose

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.

Scope

This document applies from 11gR1,

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

https://docs-stage.oracle.com/en/database/oracle/oracle-database/12.2/tgdba/gathering-database-statistics.html#GUID-309C107F-DC42-4119-9904-9504E9748B84

Details

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
Purpose
Scope
Details
References

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