Tuesday, April 19, 2011

How to Resolve Concurrent Manager Performance Issue

Concurrent Manager is the main part of an oracle EBS so we have to be proactive with Concurrent Manager's performance issue so best is to schedule below twice in a month or as required for getting optimum concurrent manager.



Gather schema stats request with parameters Schemas = All, Percentage = 99

Analyze all index columns  submit it with default options 

purge concurrent data keep only 7 days request log/output and delete old ones.

Gather table stats on the following tables and give parameter Schema= APPLSYS and percentage=99

FND_CONCURRENT_PROCESSES

FND_CONCURRENT_PROGRAMS

FND_CONCURRENT_REQUESTS

FND_CONCURRENT_QUEUES