OGG Sequence Replication Is Not Using Bind Variable And Causing KGLH0 Memory Fragmentation

(Doc ID 2407680.1)

Last updated on JUNE 21, 2018

Applies to:

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

Symptoms


We would see several sql_id's being generated during the sequence replication. The sequence replication was not using Bind Variables causing KGLH0 Memory Fragmentation and memory issues.

SQL> set lines 1000
SQL> select sql_text from v$sqlarea where sql_id='1j6d1frhjn002';

SQL_TEXT
-------------------------------------------------------------------------------------------------------------------------------------------
BEGIN OGGADMIN .replicateSequence (TO_NUMBER(223341922), TO_NUMBER(20), TO_NUMBER(1), 'HTML_OWNER', 'IS_DB_SCRIPT_CHECKSUM_SEQ', UPPER('oggadmin'), TO_NUMBER(2), TO_NUMBER (0), ''); END;

SQL> select sql_text from v$sqlarea where sql_id='6ptrk3yw6000m';

SQL_TEXT
-------------------------------------------------------------------------------------------------------------------------------------------
BEGIN OGGADMIN .replicateSequence (TO_NUMBER(223243322), TO_NUMBER(20), TO_NUMBER(1), 'HTML_OWNER', 'IS_DB_SCRIPT_CHECKSUM_SEQ', UPPER('oggadmin'), TO_NUMBER(2), TO_NUMBER (0), ''); END;

SQL> select sql_text from v$sqlarea where sql_id='621rcnptms00m';

SQL_TEXT
-------------------------------------------------------------------------------------------------------------------------------------------
BEGIN OGGADMIN .replicateSequence (TO_NUMBER(223326542), TO_NUMBER(20), TO_NUMBER(1), 'HTML_OWNER', 'IS_DB_SCRIPT_CHECKSUM_SEQ', UPPER('oggadmin'), TO_NUMBER(2), TO_NUMBER (0), ''); END;

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