Customer Interface : RACUST - Customer Interface Is Having Performance Issues (Doc ID 1116667.1)

Last updated on OCTOBER 19, 2016

Applies to:

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

Symptoms

Customer Interface program is having performance issues, and the tkprof shows the following query as the top query being executed too many times:


SELECT R.PARTY_ID, R.OBJECT_ID, O.PARTY_NAME, R.SUBJECT_ID, S.PARTY_NAME,
REL.PARTY_NUMBER, REL.PARTY_NAME
FROM
HZ_RELATIONSHIPS R, HZ_PARTIES S, HZ_PARTIES O, HZ_PARTIES REL WHERE
(R.SUBJECT_ID = :B1 OR R.OBJECT_ID = :B1 ) AND R.PARTY_ID IS NOT NULL AND
R.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND R.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND R.DIRECTIONAL_FLAG = 'F' AND R.SUBJECT_ID = S.PARTY_ID AND R.OBJECT_ID =
O.PARTY_ID AND R.PARTY_ID = REL.PARTY_ID


call    count   cpu      elapsed    disk       query      current    rows
------- ------  -------- ---------- ---------- ---------- ---------- ---------
Parse   1       0.00     0.00       0          0          0          0
Execute 4273308 114.33   106.55     0          0          0          0
Fetch   4273308 485.49   1193.31    118268     67718355   0          4258195
------- ------  -------- ---------- ---------- ---------- ---------- ---------
total   8546617 599.82   1299.86    118268     67718355   0          4258195

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