GGS_MARKER And GGS_DDL_HIST Table Maintenance For Oracle Golden Gate
(Doc ID 2404506.1)
Last updated on JANUARY 08, 2024
Applies to:
Oracle GoldenGate - Version 12.2.0.1.0 and laterInformation 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! |
In this Document
Goal |
Solution |