Purge Events From partition_historic Partition
(Doc ID 1272527.1)
Last updated on AUGUST 21, 2018
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
There are more than 48 millions records in PARTITION_HISTORIC partition, which is causing performance issues. There are 2 "old" delayed monthly partitions + current one (one delayed partition has about 20 milions records).
The user would like to purge (export and delete) some of these events. Is it better to delete them from one by one event (sub-)table or to use deletion of event object through testnap?
What is the best solution for deleting of events which are already recognized as not needed?
Note: These are placed in not-wanted partition (e.g. PARTITION_HISTORIC).
It is understood that it will be needed to change configuration (in order not to have same situation in the future), but this change of configuration will not delete old records.
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