Slower IO Performance for Incentive Compensation on RDBMS 18.104.22.168 Compated to 10.2.0.4
(Doc ID 1319099.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Oracle Incentive Compensation - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Update statement takes a long time on RDBMS Release 126.96.36.199 after having upgraded from Release 10.2.0.4.
From Oracle Incentive Compensation perspective, the following update statement shows very high I/O performance issue on RDBMS Release 188.8.131.52
(SELECT COUNT(1) FROM CN_COMMISSION_LINES WHERE
CREDITED_SALESREP_ID = A.SALESREP_ID AND PROCESSED_PERIOD_ID BETWEEN
A.PERIOD_ID AND A.END_PERIOD_ID AND PROCESSED_DATE BETWEEN A.START_DATE AND A.END_DATE), A.COMMISSION_HEADERS_COUNT = (SELECT COUNT(1) FROM
CN_COMMISSION_HEADERS WHERE DIRECT_SALESREP_ID = A.SALESREP_ID AND
PROCESSED_PERIOD_ID BETWEEN A.PERIOD_ID AND A.END_PERIOD_ID AND
PROCESSED_DATE BETWEEN A.START_DATE AND A.END_DATE) WHERE
A.LOGICAL_BATCH_ID = :B1
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!