My Oracle Support Banner

Demantra EXECUTE_PROFILES Running For Long Time (Doc ID 2528676.1)

Last updated on JUNE 10, 2019

Applies to:

Oracle Demantra Demand Management - Version 7.3.1.5 and later
Information in this document applies to any platform.

Symptoms

On : 7.3.1.5 version

Demantra EXECUTE_PROFILES running for long time

With the volume of data we have in our environment, EXECUTE_PROFILES is running for a very long time (over 9 hours) which is not feasible with our business.

Initially had error:
ORA-01555: snapshot too old: rollback segment number
That has been addressed and no errors however the process takes more than 9 hours

The process is run through a workflow with the Stored procedure step calling
the execute_profiles

Steps:
-------
1) Run Workflow
2) Performance Issue

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.