查看请求运行时长

SELECT REQUEST_ID,
request_type,
PROGRAM,
actual_start_date 开始日期,
ACTUAL_COMPLETION_DATE 完成日期,
ROUND((TO_NUMBER(ACTUAL_COMPLETION_DATE - actual_start_date) * 24 * 60),
2) RUN_TIME,
'分钟' 单位,
LAST_UPDATE_DATE,
PROGRAM_SHORT_NAME,
ARGUMENT_TEXT,
COMPLETION_TEXT,
RESPONSIBILITY_APPLICATION_ID,
phase_code,
STATUS_CODE,
PRIORITY_REQUEST_ID,
REQUESTOR
FROM FND_CONC_REQ_SUMMARY_V
WHERE
-- PHASE_CODE = 'C'
-- NVL(REQUEST_TYPE,'X') != 'S'
(TRUNC(REQUEST_DATE) >= TRUNC(SYSDATE - 1))
-- AND ROUND((TO_NUMBER(ACTUAL_COMPLETION_DATE - actual_start_date) * 24 * 60) / 60,
-- 2) > 0.1 --6分钟以上
and program like 'CUX:小米108接口通用版%'
-- and argument_text = '96, 0000101178-1110'
-- and REQUEST_ID=39968055
-- and phase_code <> 'C'
-- and argument_text ='85, 96, 2022/03/01 00:00:00, 2022/10/31 23:59:59, N, , , 331413, N, , , N, , N, , , Y, Y, , , '
-- '85, 96, 2022/03/01 00:00:00, 2022/10/31 23:59:59, N, , , 331413, N, , , N, , N, , , N, Y, , ,
-- and request_id in (39695383,39696108)
order by actual_start_date desc;