How To Drop Unused APCC Table Partitions To Deal With APCC Database Abnormal Growth
(Doc ID 2397163.1)
Last updated on MARCH 16, 2020
Applies to:Oracle Advanced Planning Command Center - Version 12.2.6 and later
Oracle Advanced Supply Chain Planning - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.
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 220.127.116.11 (VCP Patch 25074533)
After upgrade they have been experiencing continuous large growth in APCC Fact Tables of MSC Schemas.
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 ->
Search for "Cleanup Instance Partition"
Mode = Repair
This did not help, they keep running the above program as scheduled, but DB growth continues.
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