My Oracle Support Banner

Performance Issue During 'Download Unit Cost' TABLE RE-ORG TROUBLESHOOTING (Doc ID 2014522.1)

Last updated on JULY 05, 2021

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Technical

ACTUAL BEHAVIOR
---------------
Performance issue during 'Download Unit Cost'

We are running 'Download Unit Cost' to load the item cost data from EBS to Demantra Staging tables and then to Base Tables, collecting the item cost data for the month of April on Production.
Initially the workflow 'Download Unit Cost' used to take around 2.30 hrs, but in the last run it took around 36 hrs to collect the item cost for the month of April'15. We ran gather schema stats to improve the run time but it didn't help.We checked from mdp_matrix base tables using the Last update date date & time and the data was getting loaded.

We haven't faced this issue earlier on any other Development & Test Instance.

EXPECTED BEHAVIOR
-----------------------
 'Download Unit Cost' to take less time

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Running Download Unit Cost to load the item cost data from EBS to Demantra Staging Tables and then to Base Tables. Its taking more than 36 hrs to complete.

BUSINESS IMPACT
-----------------------
The issue has the following business impact: We are facing this issue on Production and we can't afford this every time we collect unit cost.

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!


In this Document
Symptoms
Changes
Cause
Solution
 -- <Document: 1964291.1> Troubleshooting TABLE_REORG Package issues
 ORA-32422 is fixed after implementing workaround from Note  <Document: 1950119.1>
 ORA-600 encountered during MDP_MATRIX table reorg
References


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