Scripts for monitoring concurrent managers

$FND_TOP/sql Scripts for monitoring concurrent managers

Script Description
Afcmcreq Prints the log file name of managers that can run a given request
Afcmstat Displays all defined managers and shows current status of manager processes
Afimchk Checks to see if the concurrent manager monitor is actually running
Afimlock Monitors locks that the ICM and CRM are waiting for. Run this if you have long delays when submitting jobs.
afimpmon Sets the PMON method based on the argument (for CONC_PMON_METHOD)
Afimveri Resets the concurrent manager monitor
Afqpmrid Returns the operating system process id of the FNDLIBR process of a concurrent manager request. Use this information to run ORADEBUG for specific requests.

$FND_TOP/sql Scripts for reviewing concurrent requests
Script Description
Afrqpend Lists all the Pending/Normal requests. These include jobs on hold, future-dated requests, and those waiting for a manager.
Afrqrun Lists all Running, Terminating, and Paused requests
Afrqscm Prints the log file names of managers that can run a given request
Afrqstat Summarizes concurrent request execution since a particular date
Afrqwait Selects all the Pending requests with status Q