My Oracle Support Banner

How To Drop Unused APCC Table Partitions To Deal With APCC Database Abnormal Growth (Doc ID 2397163.1)

Last updated on MAY 10, 2018

Applies to:

Oracle Advanced Planning Command Center - Version 12.2.6 and later
Information in this document applies to any platform.

Goal

 How To Drop Unused APCC Table Partitions To Deal With APCC Database Abnormal Growth.

Example of a Scenario:

Customer upgraded almost a year ago from 12.1.3 to 12.2.6.1 (VCP Patch 25074533)
After upgrade they have been experiencing continuous large growth in APCC Fact Tables of MSC Schemas.

Run SQL:

select * from dba_segments where owner in ('MSC','DEMANTRA') ORDER BY BYTES

Example:  See very large Byte size of MSC_ITEM_INVENTORY_F

Run "Cleanup Instance Partitions" Concurrent Program

Advanced Supply Chain Planner -> Other -> Request -> Submit a Request ->
Single Request
Search for "Cleanup Instance Partition"
Parameters:
Mode = Repair

This did not help, they keep running the above program as scheduled, but DB growth continues.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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