Physical Standby Database High Session Waiting On 'Row Cache Mutex' (Doc ID 2892534.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Problem Summary

Multiple ADG-s tied to the same primary got hung after switch over operation.
- switchover [part of patching efforts]
- new primary was ok after switchover
- DR to the primary (old primary basically) which is standby read only, but
NOT queried by anyone was fine
- extra ADG standby instances exist in 3 data centers. These instances are
open for queries all the time
- all the ADG-s standby-s got hung after the switchover.
---------------------------------------------------
physical standby database high session waiting on 'row cache mutex'

Changes

 faced during switchover of db as part of applied ru 19.15 in primary and standby

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.