#
# ORACLE Performance Tuning Appendix C p. 553
# Concurrent Request Processing
    SELECT COUNT(*)
        FROM FND_CONCURRENT_REQUEST
        WHERE REQUEST_DATE < TO_DATE
            ('&&WHEN','DD-MON-YY HH24:MI')
        AND REQUESTED_START_DATE < TO_DATE
            ('&&WHEN','DD-MON-YY HH24:MI')
        AND ACTUAL_COMPLETION_DATE > TO_DATE
            ('&&WHEN','DD-MON-YY HH24:MI');
#
    SELECT COUNT(*)
        FROM FND_CONCURRENT_REQUESTS
        WHERE ACTUAL_START_DATE-GREATEST
            (REQUEST_DATE,REQUESTED_START_DATE) > 10/(24*60*60)
            AND REQUEST_DATE > TRUNC(SYSDATE);
#
    SELECT COUNT(*)
        FROM FND_CONCURRENT_REQUESTS
        WHERE NVL(ACTUAL_COMPLETION_DATE,SYSDATE) - 
            ACTUAL_START_DATE > 1/24
            AND REQUEST_DATE > TRUNC(SYSDATE,'DAY');