Quote Originally Posted by PAVB View Post
Two questions...


1- Are tables partitioned by v_column_name ?

If yes... truncating or switching partitions are good options to take into consideration.


2- What's the percentage of rows being deleted?

A high percentage purge works faster doing a reverse purge, instead of deleting what you don't want anymore, bulk insert what you want in a new incarnation of the same table.
1. No

In DB_CLEANUP_PARAMETERS I have the following entries:

TABLE_NAME DATE_FIELD_NAME RETENTION_DAYS
------------------------------------------------------------
PH_EVENT TO_DATE 100
PH_ACCOUNT END_DATE 150
PH_CONTACT DATE_TO 50

PH_EVENT, PH_ACCOUNT, PH_CONTACT are tables from database which have around 8 million records. From these table I have to delete all the records where the corresponding column is greater than (SYSDATE + RETENTION_DAYS).

2. Between 70 and 90%