Oracle Concurrent Manager – CP Analyzer for E-Business Suite



Last updated on November 23rd, 2015 at 04:43 am

The Concurrent Processing Analyzer is a Self-Service Health-Check script which reviews the overall Concurrent Processing Footprint(Oracle Concurrent manager) , 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
1) 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
2)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
3) 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
4)Identifies Concurrent System Setup and configurations
5)Identifies and recommends Concurrent Best Practices
6)Easy to add Tool for regular Concurrent Maintenance
7)Execute Analysis anytime to compare trending from past outputs•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.

How to run the Oracle Concurrent Manager – CP Analyzer for E-Business Suite

1. Download the latest cp_analyzer.sql script:

2. Log into sql*plus as the APPS user to run the script. This script could take approximately 30 minutes.

Example:

sqlplus apps/ @cp_analyzer.sql

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


Leave a Reply