My Oracle Support Banner

Concurrent Processing - CP Analyzer Sample SQL Statements Including Date Range Parameters from Doc 1411723.1- Concurrent Processing - CP Analyzer for E-Business Suite (Doc ID 1499538.1)

Last updated on APRIL 04, 2021

Applies to:

Oracle Concurrent Processing - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Purpose

This document is a reference document for <Document 1411723.1> the EBS Concurrent Processing Analyzer. 

The details in this document provides advanced sql query statements allowing select date ranges etc for monitoring Concurrent Processing. 

The scripts are useful for specific Concurrent Processing (monitoring / problem isolation) needs as referenced below.

NOTE: The scripts are samples and intended for use at your own risk.  They are intended to be modified as needed per site requirements.

 

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 Script Provides Daily Concurrent Request Counts Completed by Hour
 Script Provides the Concurrent Requests Counts, Time, and Range
 Script Provides the Count by Name and Date
 Script Provides the Count of Requests Completed and Canceled
 Script Provides the Count of Requests Completed with Error
 Script Provides the Count of Requests Pending and Scheduled
 Script Provides the Count of Requests Terminated by Date
 Script Provides the Count of Requests by Date
 Quick Sql Statement to check Average Monthly Requests
 Script Identifying Concurrent Managers Used and Compare
 Elapsed Time History for All Requests Run for a Given Time Period
 Select for Providing Frequency/Volume Analysis Program Name, Queue Name, and Count by Program Name and Date Range
 Request Volume Per Day Select which can be Modified with Additions to the Where Clause
 Select Providing the Volume of Concurrent Requests Per Node
 Select reflecting All Requests with Run Times > 30 Minutes During Peak Load in the Past Month by Application_Id
 Select Providing Request ID's for Requests that are Currently Running
 Session Information Available from an Oracle Unix Process ID - SPID
 Tracing Concurrent Processes
 Recommended Concurrent Processing Resources
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.