OSM: Partition Purge: Estimation (Doc ID 2755706.1)

Last updated on MARCH 31, 2023

Applies to:

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

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