My Oracle Support Banner

OSM: Partition Purge: Estimation (Doc ID 2755706.1)

Last updated on FEBRUARY 25, 2021

Applies to:

Oracle Communications Order and Service Management - Version 7.3.5.0.0 and later
Information in this document applies to any platform.

Goal

We had tried to use the estimation package for partition purge but the actual results are different than estimation, do we have any other proper formula to estimate accurately.

Example:

Estimated space claim: 35 MB
Actual: 26 GB

declare
begin
  dbms_output.put_line('Partition size:' ||
  om_part_maintain.estimate_ptn_purged_space(
  a_delete_before=> trunc(sysdate)-21,
  a_order_states=>om_new_purge_pkg.v_closed_or_cancelled_orders,
  a_order_id_lt=>1999773,
  a_order_id_ge=>1800019));
end;

exec om_part_maintain.purge_partitions(a_online => false, a_delete_before=> trunc(sysdate)-21, a_order_states=>om_new_purge_pkg.v_closed_or_cancelled_orders, a_order_id_ge => 1800019), a_order_id_lt =>1999773, a_drop_empty_ptns => true);
 

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.