OGG IR using the hint "streams or_expand() restrict_all_ref_cons" with DECODE and performing FTS and not using INDEX of the table
(Doc ID 2527370.1)
Last updated on MARCH 30, 2021
Applies to:Oracle GoldenGate - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
Oracle GoldenGate Integrated Replicat process is very slow. When checked the Healthcheck report, it was performing a FTS (Full Table Scan) on a table with the below hint,
Below was the statement,
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