How To Drop Unused APCC Table Partitions To Deal With APCC Database Abnormal Growth
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.
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 126.96.36.199 (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.
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 hundreds of Community platforms