My Oracle Support Banner

MSC_REGIONS_TEMP - How To Control Growth And Explain Purge Options (Doc ID 2792970.1)

Last updated on JULY 19, 2021

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

1. As suggested in an earlier SR, we try to manually truncate the table, but we are 24x7 operation and we keep seeing error - ORA-00054 - Resource Busy, so the table is not cleaned up.
-- If we try to do delete then we do not have any mechanism to tell which is the oldest records since there are no date columns
2. Why this is not part of "Purge ATP Temp Tables". This is certainly a TEMP table ?
3. What is the best way to purge this table to keep a consistent performance in ATP inquiry and scheduling operations?

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!


In this Document
Goal
Solution
References


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