Integrated Extract Taking More Time -- Latency Increasing
(Doc ID 2165035.1)
Last updated on JUNE 26, 2024
Applies to:
Oracle GoldenGate - Version 12.2.0.1.0 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.0.1.0 version, 1 - Oracle DB backend
ACTUAL BEHAVIOR
---------------
integrated extract taking more time -- latency increasing
integrated extract running slow.
GGSCI> info all
Program Status Group Lag at Chkpt Time Since Chkpt
Showing lot of contention related to logminer.
2019 23 SYS enq: MN - contention
2026 7755 SYS enq: MN - contention
2080 31 SYS enq: MN - contention
select sql_id,event from gv$session where username='SYS' and event like 'enq%';
SQL_ID EVENT
------------- ----------------------------------------------------------------
enq: MN - contention
enq: MN - contention
enq: MN - contention
enq: MN - contention
0x23z2wh2v51p enq: MN - contention
f5t1q596tgph2 enq: MN - contention
enq: MN - contention
enq: MN - contention
66psxy475hy2r enq: MN - contention
enq: MN - contention
enq: MN - contention
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 |
Cause |
Solution |
References |