Extract Generates a Large Volume of Trail Data for Lob Updates on Oracle

(Doc ID 1206737.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle GoldenGate - Version 10.4.0.0 and later
Information in this document applies to any platform.
Checked for relevance on 26-Nov-2013

Symptoms

Some examples of excessive trails generation are :-

    Generated 8.8GB of trail when redo log was only generated ~ 20MB,

    Generated 100GB of Trail for a 245mb update.

When you look at the logminer log miner shows the following repeating over and over.

SEL_LOB_LOCATOR 08/21/10 12:57:37 TABLE FM_COV_LIST
LOB_WRITE 08/21/10 12:57:37 TABLE FM_COV_LIST
LOB_WRITE 08/21/10 12:57:37 TABLE FM_COV_LIST
INTERNAL 08/21/10 12:57:37 TABLE FM_COV_LIST
INTERNAL 08/21/10 12:57:37 TABLE FM_COV_LIST
SEL_LOB_LOCATOR 08/21/10 12:57:37 TABLE FM_COV_LIST
LOB_WRITE 08/21/10 12:57:37 TABLE FM_COV_LIST
LOB_WRITE 08/21/10 12:57:37 TABLE FM_COV_LIST
INTERNAL 08/21/10 12:57:37 TABLE FM_COV_LIST
INTERNAL 08/21/10 12:57:37 TABLE FM_COV_LIST
INTERNAL 08/21/10 12:57:37 TABLE FM_COV_LIST

Cause

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