OGG Integrated Extract LOB Fetch Using Rowid Always Fails Causing Performance Issues

(Doc ID 2305030.1)

Last updated on SEPTEMBER 15, 2017

Applies to:

Oracle GoldenGate - Version to [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 <==


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