GGS_DDL_HIST And GGS_MARKER Tables Fragmented (Doc ID 1906439.1)

Last updated on JULY 22, 2015

Applies to:

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

Goal

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.
 

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