Oracle Apps DBA Scripts

First of all I want to thank RAMNIK, (Oracle Apps DBA) for his valuable suggestion on improving this site for Oracle Apps DBA's. I dedicate this page to RAMNIK who inspired me to put all scripts related to Oracle Apps 11i useful for Oracle Apps DBA. For now I am putting all scripts in one place & once I have good repository, I'll arrange them with respect to component.

If you have some useful scripts related to Apps DBA job (Related to Concurrent manager, forms, compilation, tuning apps..., monitoring ) and you want to share with others then mail Me.

* Below script are from metalink and oracle reserved the copyrights. These scripts are mentioned here for information only

For Apps DBA the good place to serach for script is with in their installation of 11i. The path is $FND_TOP/sql (Usually on Concurrent Manager Node). The following SQL scripts located under $FND_TOP/sql are useful when diagnosing concurrent manager problems:

afimchk.sql Tells the status of the ICM and PMON method

afcmstat.sql Lists active manager processes

afrqrun.sql Lists all the running, waiting and Terminating requests

afrqwait.sql Lists requests that are constrained and waiting for the ICM to release them.

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.

afcmcreq.sql Prints the log file name of the manager that processed the request

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.

afimlock.sql Lists locks that the ICM is waiting to get

afcmrrq.sql Lists managers that currently are running a request

Patch Info Scripts