Concurrent FND scripts
Concurrent FND scripts
$FND_TOP/sql 下有很多现成Concurrent Program相关脚本
afcmstat.sql Lists active manager processes
afrqrun.sql Lists all the running, waiting and Terminating requests（列出所有正在Running的脚本）
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.
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..
afimlock.sql Lists locks that the ICM is waiting to get
afcmrrq.sql Lists managers that currently are running a request
Note:ICM means Internal Concurrent Manager
运行方法
1.登陆Sqlplus,eg. sqlplus apps/apps@instance
2.Sqlplus下，执行
SQL> @$FND_TOP/sql/afimchk.sql
Common SQL Decodes - FCR
Common SQL Decodes - FCR
DECODE(fcr.phase_code,
'C', 'Completed',
'I', 'Inactive',
'P', 'Pending',
'R', 'Running',
fcr.phase_code)
...
FROM fnd_concurrent_requests fcr
DECODE(fcr.status_code,
'A', 'Waiting', 'B', 'Resuming',
'C', 'Normal', 'D', 'Cancelled',
'E', 'Errored', 'F', 'Scheduled',
'G', 'Warning', 'H', 'On Hold',
'I', 'Normal', 'M', 'No Manager',
'Q', 'Standby', 'R', 'Normal',
'S', 'Suspended', 'T', 'Terminating',
'U', 'Disabled', 'W', 'Paused',
'X', 'Terminated', 'Z', 'Waiting',
fcr.status_code)
...
FROM fnd_concurrent_requests fcr
Common SQL Decodes - FCPG
DECODE (fcpg.execution_method_code,
'A', 'Spawned',
'F', 'Flexsql',
'H', 'Host',
'I', 'PL/SQL',
'L', 'SQL*Loader',
'P', 'Oracle Rpt',
'Q', 'SQL*Plus',
'R', 'SQL*Report',
'S', 'Immediate',
'X', 'FlexRpt',
fcpg.execution_method_code),
...
FROM fnd_concurrent_programs fcpg
转载请注明出处：http://blog.csdn.net/pan_tian/article/details/7702645
======EOF======
