Excessive "reliable Message" waits seen on RAC after a few days uptime
Last updated on NOVEMBER 20, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 12.1]
Information in this document applies to any platform.
"reliable message" waits can exceed 1 second.
This is for a 126.96.36.199 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms