My Oracle Support Banner

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

Last updated on APRIL 13, 2022

Applies to:

Oracle Data Integrator - Version 12.2.1.3.190415 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.

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
References


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