Concurrent Processing - CP Analyzer for E-Business Suite

Print this post

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

Audience

• DBA's / System Administrator's should run the script and review the output
• Pending the output, one may interact with the the following End-User types to resolve the identified Opportunity Improvement areas:
  • Apps Access (Toad or SQL Developer)
  • Filesystem access (apps logfiles) $APPLCSF/$APPLLOG
  • SYSADMIN access permissions
• Output usually will be reviewed by a group of people pending the problems
• This script was designed for Concurrent Processing in 11.5.x and later.

Where to Run Script & How to fix Items Identified in Script:
You may run the script on a Production environment as it's non-invasive.  We recommend fixing items identified from the output first in a clone of production to test/verify the expected outcome.

For script and more information, Concurrent Processing - CP Analyzer for E-Business Suite [ID 1411723.1]