My Oracle Support Banner

ODI Mapping Execution Ignoring Oracle Database Hints (Doc ID 2861321.1)

Last updated on OCTOBER 27, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.3.190415 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Symptoms

When adding hints to an Oracle Data Integrator (ODI) mapping, the hints are ignored and not sent to the database with the query.

For example, the following two examples are different hints added for the performance improvement of a fact table. When executing the mapping with these hints (@SEL$3 and @SEL$30) they are not included.

Hints as declared:

Note that in the execution log, the hints @"SEL$3" and @"SEL$30" are missing.

Changes

 

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!

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