[Oracle EBS] Purge Concurrent Request and/or Manager Data

One of the important area of Concurrent Manager tuning is monitoring the space usage for the subsets within each concurrent manager. When the space in FND_CONCURRENT_PROCESSES and FND_CONCURRENT_REQUESTS exceed 50K, you can start to experience serious performance problems within your Oracle Applications. When you experience these space problems, a specific request called “Purge Concurrent Requests And/Or Manager Data” should be scheduled to run on a regular basis. This request to purge can be configured  the request data from the FND tables as well as the log files and output files on accumulate on disk.

When the tables FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROCESSES reaches above 3000-4000 rows, the performance diminishes. You have to run Purge Concurrent Request and/or Manager Data program on a regular basis depending on the amount of request being run.

Query Find Size in KB for FND_CONCURRENT_REQUESTS 
SELECT (BYTES/1024)/1024 "Size in KB" from dba_segments where SEGMENT_NAME='FND_CONCURRENT_REQUESTS';

SELECT (BYTES/1024)/1024 "Size in KB" from dba_segments WHERE SEGMENT_NAME='FND_CONCURRENT_PROCESSES';

How to run Purge Concurrent Request and/or Manager Data in oracle EBS

1. Log in to Application as System Administrator responsibility.
2. Navigate to Request> Run> Single Request
3. Query up Purge Concurrent Requests.

ENTITY = ALL   : Purge of concurrent requests, concurrent managers, request log files, manager log files and report output files. The following tables are purged
-  Fnd_Concurrent_Processes
-  Fnd_Dual
-  Fnd_Concurrent_Requests,
-  Fnd_Run_Requests
-  Fnd_Conc_Request_Arguments
-  Fnd_Dual
-  Fnd_Context_Env
-  Deletes concurrent requests’ log and out files from OS

ENTITY = MANAGER   : Purge of concurrent managers and manager log files.
The following tables are purged 
-  Fnd_Concurrent_Processes
-  Fnd_Dual
-  Deletes concurrent manager log files from OS

ENTITY = REQUEST   : Purge of concurrent requests, request log files and output files.
The following tables are purged
– Fnd_Concurrent_Requests,
– Fnd_Run_Request
– Fnd_Conc_Request_Arguments
– Fnd_Dual
– Deletes concurrent requests’ log and out files from OS

MODE : 
- AGE : Number of days.
- COUNT : Number of records

Artikel Terkait :

• [Oracle EBS] Purge Concurrent Request and/or Manager Data
• [Oracle EBS] Query to list Reports assigned to a Responsibility
• [Oracle EBS] Query to list Active Responsibilities assigned to Active User
• [Oracle EBS] GL Journals Stuck With Funds Status In Process
• [Oracle EBS] Fixed Asset Error APP-OFA-48392 in Asset Workbench
• [Oracle EBS] ORA-01591 In-Doubt Transactions
• [Oracle EBS] Query to list Reports assigned to a Responsibility
• [Oracle EBS] Query Period Status
• [Linux] Transfer Files Or Folder Using SCP
• [Oracle EBS] Query To Find Application Name And Short Name
• [PostgreSQL] Truncate Table and Reset Sequence
• [Oracle Siebel CRM] Query Last User Active