FBDA: Flashback Data Archive Target Database Causing TX Row Lock Contention On SYS_FBA_TCRV_% internal Table
(Doc ID 2636495.1)
Last updated on MARCH 02, 2021
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
ORCL has FBDA enabled on a number of tables that are being replicated via GoldenGate.
We are seeing TX row lock on internal FBDA tables causing GG to wait on the lock to be released. This is causing severe delay in the Data flow. System was running transactions without performance issues and GG was running with no lag until Source database load was increased.
Need to determine cause of FBDA TX contention.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!