My Oracle Support Banner

APCC Archive Summary is Taking too Long to Complete (Doc ID 1498306.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Planning Command Center - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 02-JUN-2014***

Symptoms

In Advanced Planning Command Center on a 12.1.3 Instance, Performance

ACTUAL BEHAVIOR  
---------------
We are running ASCP plans with Archive Summary set to yes.  We have noticed that the archive processes are taking an hour plus to complete whereas the ascp plan is completing in half an hour or so.  We run gather schema at 20 percent once a week.  We believe that the apcc archive process taking an hour plus is too long.

We have tried running GSS multiple times for msc schema, but the performance hasn't improved.

EXPECTED BEHAVIOR
-----------------------
Expect the Archive Plan Summary to take 20 minutes to complete.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ASCP plans with Archive Summary set to Yes
2. Note the performance issue described above.

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.