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 and later
Information in this document applies to any platform.


On : 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

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

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