Extract Generates a Large Volume of Trail Data for Lob Updates on Oracle (Doc ID 1206737.1)

Last updated on FEBRUARY 22, 2019

Applies to:

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

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