select * from apps.fnd_concurrent_requests where STATUS_CODE = 'I' AND phase_code = 'P'
状态(STATUS_CODE):
已取消 D
已禁用 U
错误 E
无管理程序 M
正常 R
暂挂 H
暂停 W
重新开始 B
已计划 I
准备 Q
挂起 S
已终止 X
终止 T
等待中 A
警告 G
I应该是Inactive
另外 四个阶段(PHASE_CODE):
已完成 C
无效 I
等待 P
运行中 R
附: 获取近期 concurrent request 的执行时间(不同参数下的) :
SELECT fcr.CONCURRENT_PROGRAM_ID,
fcp.CONCURRENT_PROGRAM_NAME,
fcp_tl.USER_CONCURRENT_PROGRAM_NAME,
fcr.REQUEST_ID,
fcr.request_date,
fcr.NUMBER_OF_ARGUMENTS,
fcr.ARGUMENT_TEXT,
ROUND ((24 * 60 * 60
* (NVL (fcr.actual_completion_date, fcr.actual_start_date)
- fcr.actual_start_date)),2) elapsed_time,
fcr.RESUBMIT_INTERVAL,
fcr.RESUBMIT_INTERVAL_UNIT_CODE
FROM apps.fnd_concurrent_requests fcr,
APPS.fnd_concurrent_programs fcp,
APPS.fnd_concurrent_programs_tl fcp_tl
WHERE fcr.CONCURRENT_PROGRAM_ID = fcp.CONCURRENT_PROGRAM_ID
AND fcr.phase_code = 'C'
AND fcr.request_date > SYSDATE - 30
AND fcr.request_date <= SYSDATE - 1
AND fcr.CONCURRENT_PROGRAM_ID = fcp_tl.CONCURRENT_PROGRAM_ID
--- and fcp_tl.USER_CONCURRENT_PROGRAM_NAME like 'HW%'
ORDER BY fcr.concurrent_program_id , fcr.request_id ;
状态(STATUS_CODE):
已取消 D
已禁用 U
错误 E
无管理程序 M
正常 R
暂挂 H
暂停 W
重新开始 B
已计划 I
准备 Q
挂起 S
已终止 X
终止 T
等待中 A
警告 G
I应该是Inactive
另外 四个阶段(PHASE_CODE):
已完成 C
无效 I
等待 P
运行中 R
附: 获取近期 concurrent request 的执行时间(不同参数下的) :
SELECT fcr.CONCURRENT_PROGRAM_ID,
fcp.CONCURRENT_PROGRAM_NAME,
fcp_tl.USER_CONCURRENT_PROGRAM_NAME,
fcr.REQUEST_ID,
fcr.request_date,
fcr.NUMBER_OF_ARGUMENTS,
fcr.ARGUMENT_TEXT,
ROUND ((24 * 60 * 60
* (NVL (fcr.actual_completion_date, fcr.actual_start_date)
- fcr.actual_start_date)),2) elapsed_time,
fcr.RESUBMIT_INTERVAL,
fcr.RESUBMIT_INTERVAL_UNIT_CODE
FROM apps.fnd_concurrent_requests fcr,
APPS.fnd_concurrent_programs fcp,
APPS.fnd_concurrent_programs_tl fcp_tl
WHERE fcr.CONCURRENT_PROGRAM_ID = fcp.CONCURRENT_PROGRAM_ID
AND fcr.phase_code = 'C'
AND fcr.request_date > SYSDATE - 30
AND fcr.request_date <= SYSDATE - 1
AND fcr.CONCURRENT_PROGRAM_ID = fcp_tl.CONCURRENT_PROGRAM_ID
--- and fcp_tl.USER_CONCURRENT_PROGRAM_NAME like 'HW%'
ORDER BY fcr.concurrent_program_id , fcr.request_id ;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-768683/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-768683/