Excessive "reliable Message" waits seen on RAC after a few days uptime
(Doc ID 1990796.1)
Last updated on SEPTEMBER 04, 2022
Applies to:Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 12.1]
Information in this document applies to any platform.
"reliable message" waits can exceed 1 second.
This is for a 188.8.131.52 database (non-pluggable).
The problem does not manifest until a few days of up-time
The only workaround is to restart the instance.
Performance is affected severely for example a truncate command can take 20 minutes or more and AWR reports show high wait time for "reliable message".
A hang analyze will also show
service name: SYS$BACKGROUND
Current Wait Stack:
1: waiting for 'CSS group membership query'
CSS group membership query's are not processed fast enough because of congestion.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!