Oracle sql report concurrent 查詢 請求 執行 時間 分鐘
SELECT /*+ rule */
rq.parent_request_id,
rq.request_id,
tl.user_concurrent_program_name,
rq.actual_start_date,
rq.actual_completion_date,
ROUND((rq.actual_completion_date - rq.actual_start_date) * 1440, 2) run_time_min
FROM fnd_concurrent_programs_vl tl,
fnd_concurrent_requests rq
WHERE tl.application_id = rq.program_application_id
AND tl.concurrent_program_id = rq.concurrent_program_id
AND rq.actual_start_date IS NOT NULL
AND rq.actual_completion_date IS NOT NULL
ORDER BY rq.actual_completion_date DESC;