AOL Query executing 2000/sec in AWR Report
I am reviewing an AWR report from a newly implemented R12 environment, in the sql section of the report I am seeing the following query:
7,364.1870,549,8560.007.89100.860.001mr4u2r99v9vce::fwk:fnd.sso.login.server.MainLoginPageAM SELECT PHASE_CODE, STATUS_CODE...
SELECT PHASE_CODE, STATUS_CODE, COMPLETION_TEXT, PHASE.LOOKUP_CODE, STATUS.LOOKUP_CODE, PHASE.MEANING, STATUS.MEANING FROM FND_CONCURRENT_REQUESTS R, FND_CONCURRENT_PROGRAMS P, FND_LOOKUPS PHASE, FND_LOOKUPS STATUS WHERE PHASE.LOOKUP_TYPE = :B3 AND PHASE.LOOKUP_CODE = DECODE(STATUS.LOOKUP_CODE, 'H', 'I', 'S', 'I', 'U', 'I', 'M', 'I', R.PHASE_CODE) AND STATUS.LOOKUP_TYPE = :B2 AND STATUS.LOOKUP_CODE = DECODE(R.PHASE_CODE, 'P', DECODE(R.HOLD_FLAG, 'Y', 'H', DECODE(P.ENABLED_FLAG, 'N', 'U', DECODE(SIGN(R.REQUESTED_START_DATE - SYSDATE), 1, 'P', R.STATUS_CODE))), 'R', DECODE(R.HOLD_FLAG, 'Y', 'S', DECODE(R.STATUS_CODE, 'Q', 'B', 'I', 'B', R.STATUS_CODE)), R.STATUS_CODE) AND (R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID AND R.PROGRAM_APPLICATION_ID= P.APPLICATION_ID ) AND REQUEST_ID = :B1