Slower IO Performance for Incentive Compensation on RDBMS 11.2.0.2 Compated to 10.2.0.4 (Doc ID 1319099.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 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.

Symptoms

Update statement takes a long time on RDBMS Release 11.2.0.2 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 11.2.0.2

UPDATE CN_PROCESS_BATCHES A SET A.SALES_LINES_TOTAL =
(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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms