Click here to access advanced sql query statements allowing select date ranges or other sql queries for monitoring Concurrent Processing

Note: You require MOS credentials to access following scripts.

  • 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