Installing and Using Standby Statspack
(Doc ID 454848.1)
Last updated on NOVEMBER 03, 2020
Applies to:Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [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