Concurrent Manager Performance Tuning Tips in Oracle EBS R12

Hi DBA-Mates, Topic: Concurrent Manager Performance Tuning Tips in Oracle EBS R12

Hope you all are doing in your DBA life… I know it is not easy but not hard also heheh… It is our task like that we have to available 24/7.

By the way, let’s move to topic Concurrent Manager Performance Tuning Tips in r12 Oracle EBS.

Concurrent Managers in EBS R12 Performance Generic Tips:

1. Cache Size:  It means the Number of Request cached. And Cache size value should be the twice of the number of Target Processes.

For example: If a Concurrent Manager’s target value is 2, then cache size should be like 4. It means CM will read 4 request at a time and try to run these 4 requests before reading any new request.

i.e. Cache Size = 2*no. of Target Process.

2. Sleep Seconds: It is the number of seconds when Concurrent Manager waits to check the list of pending Concurrent Requests.

For Example: If the Sleep Seconds value is 2 Min (max) then CM will check Pending Concurrent Requests every 2 Min.  For peak time we can set it to 30 seconds.

3. We should not enable maximum number of Custom Managers if not required. It will degrade the performance for Queue Table.

4. We should keep less sleep time for CRM manager in peak hours.

5. Reports.log files should be always truncate from Log file location $APPLCCSF/APPLLOG. Some times its sizes increases more than 2 GB which impacts performance, so we should truncate manually.

6. More number of records in FND_Concurrent Table can slow the application performance. So, we should run the Purge Concurrent Request FNDCPPUR at regular interval.

7. We should always keep eyes on below tables

• FND_CONCURRENT_REQUESTS
• FND_CONCURRENT_PROCESSES
• FND_CRM_HISTORY
• FND_ENV_CONTEXT
• FND_TEMP_FILES
• FND_CONFLICTS_DOMAIN

These above tables should be Defragment periodically, while CM should be down.

8. We should always check for FND_Stats for the tables.

For example: 

exec fnd_stats.gather_table_stats ('APPLSYS','FND_CONCURRENT_REQUESTS',PERCENT=>99);

Hope this may useful and helpful here.

Some more useful links:

ADOP Phases in R12.2 Oracle EBS

Why We are not Rich

How to increase Java heap size in Hyperion

Difference between fnd_conc_clone.setup_clean and cmclean

Why we enable Maintenance Mode in R12.1.3

(Ref. 1057802.1)

Regards,