Managing Concurrent Processing Files and Tables
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 Applications and operating system processes.
This table collects runtime performance statistics for concurrent requests.
This table contains the concurrent program performance statistics generated by the Purge Concurrent Request and/or Manager Data program. The Purge Concurrent Request and/or Manager Data program uses the data in FND_CONC_STAT_LIST to compute these statistics.
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 Applications 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 Applications.
- 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.
Purging loses Audit data
When you purge concurrent request information, you lose audit details. The Signon Audit Concurrent Requests report uses this audit information.
Overview of Concurrent Processing
Life cycle of a concurrent request
Reviewing Requests, Request Log Files, and Report Output Files
Purge Concurrent Request and/or Manager Data Program
Completed Concurrent Requests Report