Party Merge Performance Issue

(Doc ID 1969756.1)

Last updated on FEBRUARY 23, 2015

Applies to:

Oracle Trading Community - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, Data Quality Management

Party Merge is taking very long time.

Due to this issue, users cannot finish their business tasks in time.

Below query takes a lot of time

SELECT PARTY.NAME
FROM
OKC_K_PARTY_ROLES_V PROLE, OKX_PARTIES_V PARTY WHERE PARTY.ID1 =
 PROLE.OBJECT1_ID1 AND PROLE.CHR_ID = :B1 AND PROLE.CLE_ID IS NULL AND
 PROLE.RLE_CODE IN ('CUSTOMER', 'SUBSCRIBER')


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 287 0.03 0.05 0 0 0 0
Fetch 144 5557.85 5670.37 1972917 1722868254 288 143
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 432 5557.89 5670.42 1972917 1722868254 288 143

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