Concurrent Processing – Scripts

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