GGS_DDL_HIST And GGS_MARKER Tables Fragmented
Last updated on JULY 22, 2015
Applies to:Oracle GoldenGate - Version 220.127.116.11.14 and later
Information in this document applies to any platform.
DDL replication enabled and there are huge operations on temp tables. Though they are excluded, these operation are recorded in GGS_DDL_HIST table. Due to this the table has grown huge.
7 days retention has been set with parameter purge_ddl_history. But because of inserts and deletes on this table you could see lot of fragmentation.
It is now having 80 GB in which 40 GB can be freed. Need a solution.
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