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 126.96.36.199.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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!