Performance Issues Encountered during Insert into I$ steps for the HDM_IND_PRTY_ETHN Table (Doc ID 1935174.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Healthcare Analytics Data Integration - Version 2.0.2 and later
Information in this document applies to any platform.

Symptoms

ISSUE CLARIFICATION
==================
On Oracle Healthcare Analytics Data Integration (OHADI) 2.0.2 with ODI,

ACTUAL BEHAVIOR  
---------------
There is an issue during the Insert into I$ Steps for the Package - PKG_HDI_SBSCRBR.
For the initial load there are 40863042 records to be loaded into the HDM Tables.
To be on safer side data is loaded in chunks to avoid getting stuck in Insert into I$ Steps.
Currently there have been loaded about 1 million records.
Just for the 1 million records also the process is stuck at the Insert into I$ steps for the HDM_IND_PRTY_ETHN Table.

The following steps were performed:
- Started Initial Load to load 1 Billion Records from HDI_SBSCRBR Tables.
  The Load get stucked in the Insert into I$ Steps for the HDM_IND_PRTY_ETHN Table.
- Gather schema statistics for HDM & HDI schema;
- Rerun again the load process.
  This time were loaded 1 million Records and the load Inserted data in HDM_IND_PRTY_ETHN but stuck in the Insert into I$ Steps for the HDM_IND_PRTY_RC Table.
- Gather schema statistics for HDM & HDI schema.
- Rerun again the load process.
  This time loaded 1 million Records and the Load was stuck in the Insert into I$ Steps for the HDM_IND_PRTY_ETHN Table.

For others packages, the same issue of hanging in the Insert Into I$ Tables was encountered.
 

EXPECTED BEHAVIOR
-----------------------
It is expected that the insert into I$ Steps for the Package - PKG_HDI_SBSCRBR should be completed without getting stucked.

STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Started Initial Load to load 1 Billion Records from HDI_SBSCRBR Tables.
    The Load get stucked in the Insert into I$ Steps for the HDM_IND_PRTY_ETHN Table.
2. Gather schema statistics for HDM & HDI schema;
3. Rerun again tge load process.
    This time were loaded 1 million Records and the load Inserted data in HDM_IND_PRTY_ETHN but stuck in the Insert into I$ Steps for the HDM_IND_PRTY_RC Table.
4. Gather schema statistics for HDM & HDI schema.
5. Rerun again the load process.
    This time loaded 1 million Records and the Load was stuck in the Insert into I$ Steps for the HDM_IND_PRTY_ETHN Table.

Cause

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 hundreds of Community platforms