My Oracle Support Banner

GGS_MARKER And GGS_DDL_HIST Table Maintenance For Oracle Golden Gate (Doc ID 2404506.1)

Last updated on MAY 30, 2018

Applies to:

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

Goal

When DDL replication is enabled, To maintain the tablespace space usage we need to remove older data from GGS_MARKER and GGS_DDL_HIST tables. Using below 2 parameters in MANAGER file sometimes does not reclaims the space occupied by the entries for older data. OGG schema is GGADMIN and tablespace is GGADMIN_DATA.

PURGEMARKERHISTORY MINKEEPDAYS 7, MAXKEEPDAYS 15, FREQUENCYMINUTES 60
PURGEDDLHISTORY MINKEEPDAYS 7, MAXKEEPDAYS 15, FREQUENCYMINUTES 60

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.