FCCS - Consolidate Job - Low Performance

Summary:

In our Oracle FCCS environment, our "Consolidate" job runs in average during 40 minutes. Some jobs might run for more than 100 minutes.

This is quite a lot knowing that the "Consolidate" job has to run multiple time during the day during the closing period.

Content (please ensure you mask any confidential information):

How can we investigate what causes the low performance?

We already checked the activity reports but don't get useful information out of it.

We also raised a service request to request an environment Health Check (4-0000127501).

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):