OGG Integrated Extract LOB Fetch Using Rowid Always Fails Causing Performance Issues
(Doc ID 2305030.1)
Last updated on MARCH 11, 2019
Applies to:Oracle GoldenGate - Version 220.127.116.11.1 to 18.104.22.168.39 [Release 11.2]
Information in this document applies to any platform.
The issue is specially seen only on the OGG 11g builds. The stats would show failures by ROWID and successfull via Key.
*** Latest statistics since 2017-07-24 23:19:28 ***
Total inserts 0.00
Total updates 4.00
Total befores 4.00
Total deletes 0.00
Total discards 0.00
Total operations 4.00
Total row fetch attempts 8.00 <==
Total row fetch failures 4.00 <==
Total snapshot fetch by key 4.00 <==
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