My Oracle Support Banner

GG Parallel Replicat Is Extremely Slow Due To "replicateSequence" Query Against DBA_SEQUENCES View (Doc ID 2456322.1)

Last updated on JULY 20, 2024

Applies to:

Oracle GoldenGate - Version 12.3.0.1.3 and later
Information in this document applies to any platform.

Symptoms

Goldengate Parallel replicat is extremely slow when sequence replication is enabled.
We are constantly seeing "enq: IV - contention" on target DB where parallel replicat is running.

EVENT SQL_ID COUNT(*)
---------------------------------------------------------------- ------------- ----------
flashback log file write 11
libcache interrupt action by LCK 13
RMA: IPC0 completion sync 14
446axntpg0jkc 38
log file parallel write 46
row cache lock 3qnwvfgjhhwmx 83
enq: IV - contention 3qnwvfgjhhwmx 207
4zu528hx38720 211
3qnwvfgjhhwmx 268
291

=======

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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