Find Oracle Apps DBA scripts
Oracle Apps DBA Vishv Verma has published a nice summary of where
the Oracle Apps DBA can find scripts to help with the concurrent
manager. The concurrent manager is the job-scheduling component of
The following SQL scripts located under $FND_TOP/sql are useful when
diagnosing concurrent manager problems:
1. afimchk.sql Tells the status of the ICM and PMON method
2. afcmstat.sql Lists active manager processes
3. afrqrun.sql Lists all the running, waiting and terminating
4. afrqwait.sql Lists requests that are constrained and waiting for
the ICM to release them
5. afrqscm.sql Prints log file name of managers that can run a given
request. It can be used to check for possible errors when a request
stays in pending status. It requires a request id value.
6. afcmcreq.sql Prints the log file name of the manager that
processed the request
7. afrqstat.sql Summary of completed concurrent requests grouped by
completion status and execution type. It requires number of days
prior to today on which to report parameter.
8. afimlock.sql Lists locks that the ICM is waiting to get
9. afcmrrq.sql Lists managers that currently are running a request
Verma also shows techniques for checking the status of the
Log in to applications as System Administrator responsibility
and navigate to the concurrent manager administration page
(Concurrent, Manager, Administrator) and under the processes column
if the target and actual column equal the same number (above 0) this
means the managers are up and running.
2. You can also go into SQL*PLUS as APPS and run the following
This script will return output similar to the below:
Status Since Method
-------------------------------------- --------- ----------- ------
Internal Conc Manager is running on - colapp03 05-MAR-99 06:41:32 PM
Also, this on bouncing (stopping and re-starting) the concurrent
As an practice, u should stop ur concurrent manager service through
adcmctl lying under $APPLCSF/scripts/<host_sid>
whenever there's a need to shutdown n then startup ur database.
As there could be a scenario that ur ICM wont work.