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 APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 12.1.2.0.0 and laterInformation in this document applies to any platform.
Symptoms
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,
*+ streams or_expand() restrict_all_ref_cons *
Below was the statement,
update /*+ streams or_expand() restrict_all_ref_cons */ "SCHEMA_NAME" ."TABLE_NAME" p set "COLUMN_NAME"=decode(:1,'N',"COLUMN_NAME",:2)
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 |