8.6.4.4.3 Recommended Partition Maintenance

You should run partition maintenance as appropriate for your solution set. Oracle recommends that you run partition maintenance for AML on a daily basis (after setting the business date through the Calendar Manager Utility, and prior to the daily execution of batch processing), and Trading Compliance at least once a week.

Tip:

Oracle recommends that you use the P (Partition) option when running the Data Retention Manager, as it drops older partitions and adds appropriate partitions in a single run of the utility.

When performing monthly maintenance, you can add or drop a partition independently, as the following procedures describe.

Alternative Monthly Partition Maintenance

As part of an alternative method of monthly partition maintenance, you can either add or drop a monthly database partition, as the following sections describe.

Adding a Monthly Database Partition

To add a monthly partition, run the utility’s shell script as follows (See Data Retention Manager Processing Parameterstable1.fm for parameters):

run_drm_utility.sh AM M BUSINESS <object> N

where AM is the drm_operation parameter that implies adding a monthly partition.

Dropping a Monthly Database Partition

To drop a monthly partition, run the utility’s shell script as follows (See Data Retention Manager Processing Parameterstable1.fm for parameters):

run_drm_utility.sh DM M BUSINESS <object> N

where, DM is the drm_operation parameter that implies dropping a partition.