Demantra EXECUTE_PROFILES Running For Long Time
(Doc ID 2528676.1)
Last updated on JUNE 10, 2019
Applies to:Oracle Demantra Demand Management - Version 18.104.22.168 and later
Information in this document applies to any platform.
On : 22.214.171.124 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
1) Run Workflow
2) Performance Issue
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