My Oracle Support Banner

GETENV ('DELTASTATS', 'DML') Reports Different Output in Oracle GoldenGate 12.2 than Oracle GoldenGate 11.2 (Doc ID 2559738.1)

Last updated on JULY 02, 2019

Applies to:

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

Symptoms

The Heartbeat table is configured in replicat to gather Oracle GoldenGate latency and DML message number. The heartbeat table is updated every minute.

While using Oracle GoldenGate 11.2 and and Classic Replicat, RDMLDELTASTATS get the values correctly for each minute, as seen below:

 

SQL> select source_commit,delgroup,rdmldeltastats from ggadmin.GGS_HEARTBEAT_HISTORY where source_commit >= sysdate - 60/1440;

SOURCE_COMMIT DELGROUP RDMLDELTASTATS
23-MAY-18 01.11.45.000000 PM R_DSE 1
23-MAY-18 01.12.45.000000 PM R_DSE 1
23-MAY-18 01.13.45.000000 PM R_DSE 1
23-MAY-18 01.14.45.000000 PM R_DSE 1
23-MAY-18 01.15.45.000000 PM R_DSE 1
23-MAY-18 01.16.45.000000 PM R_DSE 1
.
.
23-MAY-18 01.59.45.000000 PM R_DSE 1
23-MAY-18 02.00.45.000000 PM R_DSE 1
23-MAY-18 02.01.45.000000 PM R_DSE 1
23-MAY-18 02.02.45.000000 PM R_DSE 1
23-MAY-18 02.03.45.000000 PM R_DSE 1
23-MAY-18 02.04.45.000000 PM R_DSE 1
23-MAY-18 02.05.45.000000 PM R_DSE 1
23-MAY-18 02.06.45.000000 PM R_DSE 1
23-MAY-18 02.07.45.000000 PM R_DSE 1
23-MAY-18 02.08.46.000000 PM R_DSE 1
23-MAY-18 02.09.45.000000 PM R_DSE 1
23-MAY-18 02.10.45.000000 PM R_DSE 1


But after upgrade to Oracle GoldenGate 12.2.0.1.0 and using Integrated Replicat, RDMLDELTASTATS does not show the count and comes up as 0 , unless STATS <replicat> is run from GGSCI

 

SQL> select source_commit,delgroup,rdmldeltastats from ggadmin.GGS_HEARTBEAT_HISTORY;


SOURCE_COMMIT   DELGROUP     RDMLDELTASTATS


24-MAY-18 08.15.47.000000 PM  R_DSE  82  
24-MAY-18 08.16.47.000000 PM  R_DSE  0  
24-MAY-18 08.17.47.000000 PM  R_DSE  0  
24-MAY-18 08.18.47.000000 PM  R_DSE  0  
24-MAY-18 08.19.48.000000 PM  R_DSE  0  
24-MAY-18 08.20.47.000000 PM  R_DSE  0  
24-MAY-18 08.21.47.000000 PM  R_DSE  0  
24-MAY-18 08.22.47.000000 PM  R_DSE  0  
24-MAY-18 08.23.47.000000 PM  R_DSE  0  
24-MAY-18 08.24.47.000000 PM  R_DSE  0  
24-MAY-18 08.25.48.000000 PM  R_DSE  0  
24-MAY-18 08.26.47.000000 PM  R_DSE  0  
24-MAY-18 08.27.47.000000 PM  R_DSE  0
.
.
24-MAY-18 08.59.47.000000 PM  R_DSE  0  
24-MAY-18 09.00.48.000000 PM  R_DSE  0  
24-MAY-18 09.01.47.000000 PM  R_DSE  0  
24-MAY-18 09.02.47.000000 PM  R_DSE  0
.
.
24-MAY-18 09.20.47.000000 PM  R_DSE  0  
24-MAY-18 09.21.48.000000 PM  R_DSE  0  
24-MAY-18 09.22.47.000000 PM  R_DSE  0

 


Following is the heartbeat replicat parameter file:

MAP GGS_OWNER.HEARTBEAT, TARGET GGS_OWNER.GGS_HEARTBEAT_HISTORY,
KEYCOLS (ID),
INSERTALLRECORDS,
COLMAP (USEDEFAULTS,
ID = 0,
SOURCE_COMMIT = @GETENV ('GGHEADER', 'COMMITTIMESTAMP'),
EXTRACT_NAME = @TOKEN ('CAPGROUP'),
CAPTIME = @TOKEN ('CAPTIME'),
PMPGROUP = @TOKEN ('PMPGROUP'),
PMPTIME = @TOKEN ('PMPTIME'),
DELGROUP = @GETENV ('GGENVIRONMENT', 'GROUPNAME'),
DELTIME = @DATE ('YYYY-MM-DD HH:MI:SS.FFFFFF','JTS',@GETENV ('JULIANTIMESTAMP')),
EDMLDELTASTATS = @TOKEN ('EDMLDELTASTATS'),
RDMLDELTASTATS = @GETENV ('DELTASTATS', 'DML')
);

MAP GGS_OWNER.HEARTBEAT, TARGET GGS_OWNER.GGS_HEARTBEAT,
KEYCOLS (DELGROUP),
INSERTMISSINGUPDATES,
COLMAP (USEDEFAULTS,
ID = 0,
SOURCE_COMMIT = @GETENV ('GGHEADER', 'COMMITTIMESTAMP'),
EXTRACT_NAME = @TOKEN ('CAPGROUP'),
CAPTIME = @TOKEN ('CAPTIME'),
PMPGROUP = @TOKEN ('PMPGROUP'),
PMPTIME = @TOKEN ('PMPTIME'),
DELGROUP = @GETENV ('GGENVIRONMENT', 'GROUPNAME'),
DELTIME = @DATE ('YYYY-MM-DD HH:MI:SS.FFFFFF','JTS',@GETENV ('JULIANTIMESTAMP')),
EDMLDELTASTATS = @TOKEN ('EDMLDELTASTATS'),
RDMLDELTASTATS = @GETENV ('DELTASTATS', 'DML')
);


NOTE: In 11.2 use double-quotes, in 12.2 use single quotes

Changes

Upgraded from Oracle GoldenGate 11.2 using Classic Replicat to Oracle GoldenGate 12.2 using Integrated Replicat

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.