Concurrent Manager Performance tuning R12.2
Concurrent manager process flow FNDSM is initiate the concurrent manager in OS processer. Then start the database session and read the settings. Update the fnd_concurrent_processes and fnd_concurrent_queues tables Build SQL for quiring the request queue. Execute the sql to request concurrent manager. Checking for Sleep time seconds, Pending requests Checking the “Cache size” number of requests into the execution cache. Execute the request from the execution Queue. Update the status code of the concurrent request. Execute the request and update the status code. If Concurrent Managers are not starting Check Concurrent Manager log files Click here Check the database alert log for any space issue. Check the application tier filesystem and Middle tier file system space and /tmp directory space. Check application listner Running/Not adalnctl.sh status Check if FNDSM service is Running/Not $APPLCSF/$APPLLOG/FNDSM*.log ps -ef | grep FNDSM Check tnsping to FNDSM TNS entry tn