STATSPACK REPORTS SHOW "IDLE" DATA GUARD WAIT EVENTS IN TOP 5 IN 12.2
(Doc ID 2305287.1)
Last updated on MARCH 09, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterOracle 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 Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
<
Symptoms
Some new 'idle' waits are introduced with 12.2 for Data Guard Redo Transport layer:
Data Guard: Timer
Data Guard: Gap Manager
These are not added to STATS$IDLE_EVENT table in Statspack scripts under $ORACLE_HOME/rdbms/admin.
SELECT name, wait_class FROM V$EVENT_NAME
where name like '%Data Guard%' and WAIT_CLASS = 'Idle';
NAME WAIT_CLASS
------------------------------------------ --------------------
Data Guard: Gap Manager Idle
Data Guard: Timer Idle
Data Guard: controlfile update Idle
Statspack report shows TOP 5 WAIT EVENT
Event Waits Time (s) (ms) Time
----------------------------------------- ------------ ----------- ------ ------
Data Guard: Timer 1,080 32,402 30002 33.2
Data Guard: Gap Manager 540 32,401 60002 33.2
pman timer 10,797 32,399 3001 33.2
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! |
In this Document
Symptoms |
Cause |
Solution |
Applies to: |
References |