In this Document
| Goal |
| Solution |
| References |
Applies to:
Oracle Concurrent Processing - Version 11.5.10.0 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 23-Apr-2013***
Goal
How to run the Purge Concurrent Request and/or Manager Data program and which tables does it purge?
Solution
运行清除并发请求和并发管理器数据程序
- Log in to Application as System Administrator responsibility.
- Navigate to Request> Run> Single Request
- Query up Purge Concurrent Requests.
- For values to be entered in the parameter screen refer to the Oracle
Administration System Administration Guide
The following tables will be purged depending on the value used for the Entity parameter:
| Table name | Description | Description |
|---|---|---|
| FND_CONCURRENT_REQUESTS | This table contains a complete history of all concurrent requests. | This table contains a complete history of all concurrent requests. |
| FND_RUN_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. | 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. |
| FND_CONC_REQUEST_ARGUMENTS | This table records arguments passed by the concurrent manager to each program it starts running. | 通过此表记录并发管理开始运行的每个程序的参数。 |
| FND_DUAL | This table records when requests do not update database tables. | 此表中的记录不更新数据库表的请求 |
| FND_CONCURRENT_PROCESSES | This table records information about Oracle Applications and operating system processes. | This table records information about Oracle Applications and operating system processes. |
| FND_CONC_STAT_LIST | This table collects runtime performance statistics for concurrent requests. | This table collects runtime performance statistics for concurrent requests. |
| FND_CONC_STAT_SUMMARY | 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. | 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. |
| FND_CONC_PP_ACTIONS | Stores the post request processing actions(e.g., print, notify) for each submitted request. There's a concurrent_request_id here for each request_id in the FND_CONCURRENT_REQUESTS. |
Stores the post request processing actions(e.g., print, notify) for each submitted request. There's a concurrent_request_id here for each request_id in the FND_CONCURRENT_REQUESTS. |
| FND_RUN_REQ_PP_ACTIONS | Stores the post request processing actions(e.g., print, notify) for submitted request set programs that are stored in FND_RUN_REQUESTS | Stores the post request processing actions(e.g., print, notify) for submitted request set programs that are stored in FND_RUN_REQUESTS |
| FND_ENV_CONTEXT | This table stores information about environment name and value for each of the concurrent process | 本表为每个并发进程存储关于环境名和变量的信息 |