GGS_MARKER And GGS_DDL_HIST Table Maintenance For Oracle Golden Gate
Last updated on MAY 30, 2018
Applies to:Oracle GoldenGate - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
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
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