Previous	Next		Contents	Index	Glossary	Library

The following APIs can be called by an application program or workflow function in the runtime phase to purge obsolete runtime data. These APIs are defined in the PL/SQL package called WF_PURGE.

WF_PURGE can be used to purge obsolete runtime data about completed items and processes, and also to purge information about obsolete activity versions that are no longer in use. You may want to periodically purge this obsolete data from your system to increase performance. The 3 most commonly used procedures are:

WF_PURGE.ITEMS - purge all runtime data associated with completed items, their processes, and notifications sent by them

WF_PURGE.ACTIVITIES - purge obsolete versions of activities that are no longer in use by any item.

WF_PURGE.TOTAL - purge both item data and activity data

The other auxiliary routines purge only certain tables or classes of data, and can be used in circumstances where a full purge is not desired.

• Item_Activity_Statuses

• Items

• Activities

• Notifications

• Item_Notifications

• Total

See Also