SELECT query on SYSTEM.LOGMNRGGC_GTLO is causing performance issues in a OGG environment (Doc ID 2177706.1)

Last updated on NOVEMBER 23, 2016

Applies to:

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

Symptoms

 Customer is using OGG and saw following query causing slowness

(SELECT TP.OBJ# C_KEYOBJ# , BO.SPARE2 C_OBJV#, 2 C_LVLCNT , TP.OBJ#
C_LVL1OBJ# , NULL C_LVL2OBJ# , PO.TYPE# C_LVL1TYPE# , NULL C_LVL2TYPE# ,
.........
.........
LO.LVLCNT C_LVLCNT , LO.LVL1OBJ# C_LVL1OBJ# , LO.LVL2OBJ# C_LVL2OBJ# ,
LO.LVL1TYPE# C_LVL1TYPE# , LO.LVL2TYPE# C_LVL2TYPE# , LO.LVL1NAME
C_LVL1NAME , LO.LVL2NAME C_LVL2NAME , LO.ASSOC# C_ASSOC#, LO.TS# C_TS# ,
LO.TSNAME C_TSNAME FROM SYSTEM.LOGMNRGGC_GTLO LO WHERE LO.BASEOBJ# = :B1
AND LO.BASEOBJV# = :B2 AND LO.LOGMNR_UID = 99

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 3.43 3.48 0 87649 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 3.43 3.48 0 87649 0 1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms