My Oracle Support Banner

OID 10g ODS_CHG_LOG Table Keeps Growing And It Never Purges (Doc ID 841787.1)

Last updated on AUGUST 30, 2023

Applies to:

Oracle Internet Directory - Version 10.1.2 to 10.1.4.3 [Release 10gR2 to 10gR3]
Information in this document applies to any platform.

Goal

The ODS change_log table continually increases in size, rows are not getting deleted.   Consequently, the table can get quite large or even huge.  This document provides the steps necessary to purge the changelogs using the Garbage Collection mechanism within OID.

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
References

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