PPM Purge Tool

The PPM Purge Tool is used to permanently delete (purge) stale database data by specifying purging criteria. Pay attention to the following for the use of this tool:

• To use this tool, you must have both the SYS DBA and PPM application administrator access grants.
• It is highly recommended that this tool should be installed on a dedicated server that only the tool users with both the SYS DBA and administrator access grants can have access to, rather than on an end-user's machine.

• When using this tool, the following database permissions are required:

  • create session

  • create database link

  • create procedure

  • create sequence

  • create synonym

  • create table

  • create view

  • create trigger

  • create job

  • select on v_$session

  • execute on dbms_session

  • execute on DBMS_MONITOR

  • select on v_$parameter

  • select on v_$mystat

  • select on v_$process

  • select on v_$session

  • execute on dbms_stats

• Remote access to this tool is allowed. We recommend that you do not enable it for security best practice. If you still require remote access to this tool, make sure the IP addresses are allowed.

• Follow the instructions in Administer Project and Portfolio Management about how to use this tool