Concurrent Processing Analyzer

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.

NOTE: This is a non-invasive script - (Query only) it just reports on it. The Analyzer identifies known issues and provides solutions and recommended actions to be performed for the specific 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 Processing data from a particular environment
Identifies Concurrent Processing system setup and configurations
Provides recommended actions and best practices
Runs as a standalone or Concurrent Request

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 of Pending Regularly Scheduled Requests 
• Count of Pending Non Regularly Scheduled Requests 
• Count of Pending Requests on Hold 
• Count of Pending Requests Not on Hold 
• Listing of Scheduled Requests 
• Listing of Pending Requests on Hold 
• Listing of Scheduled Requests 
• 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 
• Additional Tablespace Statistics for the FND_CONCURRENT Tables 

E-Business Applications Concurrent Manager Analysis

• Concurrent Managers Active/Enabled and Workshifts 
• Active Managers for Applications 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 

This script can be used from 11.x.

Run the Analyzer via Sql*Plus

NOTE : The Concurrent Processing Analyzer Report (CP_Analyzer_<host>.<domain>_<SID>_<date>.html) location is specified at the completion of the analyzer execution, when running via Sql*Plus

Log into SQL*Plus as the APPS user, and run the script. Example:

$ sqlplus apps/ @cp_analyzer.sql


SQL*Plus: Release 11.2.0.3.0 - Production on Mon Apr 17 23:03:13 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Output Files are located on Host : .
Output file : 
    /usr/tmp/CP_Analyzer_.__.html
Log file: 
    /usr/tmp/CP_Analyzer_.__.log


PL/SQL procedure successfully completed.

Complete Information can be obtained from Doc ID 1411723.1 EBS Concurrent Processing (CP) Analyzer