My Oracle Support Banner

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.