STATSPACK REPORTS SHOW "IDLE" DATA GUARD WAIT EVENTS IN TOP 5 IN 12.2

(Doc ID 2305287.1)

Last updated on SEPTEMBER 12, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 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

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 hundreds of Community platforms