查询ERP系统中耗时较长的报表及并发程序

通过如下代码可以很方便地查看那些报表运行速度比较慢：

SELECT REQUEST_ID,
       PROGRAM,
       REQUESTED_START_DATE 提交日期,
       ACTUAL_COMPLETION_DATE 完成日期,
       ROUND((TO_NUMBER(ACTUAL_COMPLETION_DATE - REQUESTED_START_DATE) * 24 * 60) / 60,
             2) RUN_TIME,
       '小时' 单位,
       LAST_UPDATE_DATE,
       PROGRAM_SHORT_NAME,
       ARGUMENT_TEXT,
       COMPLETION_TEXT,
       RESPONSIBILITY_APPLICATION_ID,
       STATUS_CODE,
       PRIORITY_REQUEST_ID,
       REQUESTOR
  FROM FND_CONC_REQ_SUMMARY_V
 WHERE PHASE_CODE = 'C'
   AND (NVL(REQUEST_TYPE,
            'X') != 'S')
   AND (TRUNC(REQUEST_DATE) >= TRUNC(SYSDATE - 7))
   AND ROUND((TO_NUMBER(ACTUAL_COMPLETION_DATE - REQUESTED_START_DATE) * 24 * 60) / 60,
             2) > 0.1 --6分钟以上 
 ORDER BY REQUEST_ID DESC,
          RUN_TIME;