The Concurrent Processing Analyzer is a Self-Service Health-Check script which reviews the overall Concurrent Processing Footprint, analyzes the current configurations and settings for the environment providing feedback and recommendations on Best Practices.
This is a non-invasive script which provides recommended actions to be performed on the instance it was run on and can be run at any time. For production instances, always apply any changes to a recent clone to ensure an expected outcome.
Benefits
- Immediate Analysis and Output of Concurrent Environment
- E-Business Applications Concurrent Processing Analyzer Overview
- Total Purge Eligible Records in FND_CONCURRENT_REQUESTS
- E-Business Suite Version
- Concurrent Processing Database Parameter Settings
- Applied ATG Patches
- Known 1-Off Patches on top of Rollups
- E-Business Applications Concurrent Request Analysis
- Long Running Reports During Business Hours
- Elapsed Time History of Concurrent Requests
- Requests Currently Running on a System
- FND_CONCURRENT_REQUESTS Totals
- Running Requests
- Total Pending Requests by Status Code
- Count Pending Regularly Scheduled/Non Regularly-Scheduled Requests
- Count of Pending Requests on Hold/Not on Hold
- Listing of Scheduled Requests
- Listing of Pending Requests on Hold
- Listing of Pending Requests Not on Hold
- Volume of Daily Concurrent Requests for Last Month
- Identify/Resolve the Pending/Standby Issue, if Caused by Run Alone Flag
- Tablespace Statistics for the fnd_concurrent tables
- E-Business Applications Concurrent Manager Analysis
- Concurrent Managers Active and Enabled
- Concurrent Manager Processes by Workshift
- Active Manager for Applications that are not Installed/Used
- Total Target Processes for Request Managers (Excluding Off-Hours)
- Request Managers with Incorrect Cache Size
- Concurrent Manager Request Summary by Manager
- Check Manager Queues for Pending Requests
- Check the Configuration of OPP
- Identifies Concurrent System Setup and configurations
- Identifies and recommends Concurrent Best Practices
- Easy to add Tool for regular Concurrent Maintenance
- Execute Analysis anytime to compare trending from past outputs
Download the Concurrent Processing Analyzer Latest Version (v1.03)
Review a sample output here.
Check out a short 9 min video CP Analyzer Tutorial (09:00)
Enjoy troubleshooting! Have a great Day!
Oadba's Blog 