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 APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version 12.1.2.0.0 and later
Information 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


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