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:
Oracle GoldenGate - Version 10.4.0.0 and laterInformation 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
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
Symptoms |
Cause |
Solution |
References |