This section explains how to maintain the number of log and output files the operating system retains, and how to manage Application Object Library database tables that store information about concurrent requests and concurrent manager processes.
The database tables that are affected by running the Purge Concurrent Request and/or Manager Data program are:
This table contains a complete history of all concurrent requests.
When a user submits a report set, this table stores information about the reports in the report set and the parameter values for each report.
This table records arguments passed by the concurrent manager to each program it starts running.
This table records when requests do not update database tables.
This table records information about Oracle E-Business Suite and operating system processes.
This table collects runtime performance statistics for concurrent requests.
Your MIS department and application users should agree on an archiving and file retention policy that is appropriate for your organization. To avoid running out of space on your disk drives, you should periodically delete Oracle E-Business Suite log files and output files.
Suggestion: You can run the program "Purge Concurrent Request and/or Manager Data" once and automatically resubmit the program for you at specific time intervals.
There are some sample guidelines for when to run the Purge Concurrent Requests and/or Manager Data program. Adopt these guidelines according to your user community's usage of Oracle E-Business Suite.
every 30 days for normal usage
every two weeks (14 days) for heavy usage
if using the AGE mode, set the Mode Value to 5 to retain the five most recent days of concurrent request data, log files, and report output files.
When you purge concurrent request information, you lose audit details. The Signon Audit Concurrent Requests report uses this audit information.