My Oracle Support Banner

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 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,

*+ 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)



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.