Apply Servers Waiting on RO Enqueue
(Doc ID 787672.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 to 22.214.171.124 [Release 10.2 to 11.2]
Information in this document applies to any platform.
Checking DBA_APPLY_PROGRESS for APPLY Latency
One of the Apply server will be waiting for RO Enqueue.
This could also be confirmed from systemstate dump
COLUMN 'Latency in Seconds' FORMAT 999999
COLUMN 'Message Creation' FORMAT A17
COLUMN 'Apply Time' FORMAT A17
COLUMN APPLIED_MESSAGE_NUMBER HEADING 'Applied|Message|Number' FORMAT 999999
(APPLY_TIME-APPLIED_MESSAGE_CREATE_TIME)*86400 "Latency in Seconds",
TO_CHAR(APPLY_TIME,'HH24:MI:SS MM/DD/YY') "Apply Time",
Offending SQL statement will be:
The holder process will be the CKPT process .CKPT process will be just waiting for 'rdbms ipc message'
Find the list of sessions holding/waiting for RO Enqueue:
Sessions holding RO Enqueue and blocking:
Find the SQL's being executed by these sessions:
where s.sql_address = tx.address
and s.sql_hash_value = tx.hash_value
and s.sid = <SID> /* Provide the SID acquired from previous Queries */
order by tx.piece;
The waiting Session should return:
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