Performance Issue in Import Items (INCOIN) Concurrent Program With INSERT INTO ICX_CAT_ENDECA_ITEM_ATTRIBUTES (Doc ID 2126409.1)

Last updated on APRIL 12, 2016

Applies to:

Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version

ACTUAL BEHAVIOR
---------------
Import Items (INCOIN) concurrent program performance issue, TKPROF trace shows the following:



SELECT /*+ DYNAMIC_SAMPLING(0) INDEX(i) */ TOKEN_FIRST,TOKEN_LAST,
TOKEN_COUNT,ROWID
FROM
"ICX"."DR$ICX_CAT_ITEMSCTXDESC_HDRS$I" i WHERE TOKEN_TEXT = :word AND
TOKEN_TYPE = :wtype ORDER BY TOKEN_TEXT, TOKEN_TYPE, TOKEN_FIRST

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 867 0.00 0.01 0 0 0 0
Execute 3468 0.05 0.05 0 0 0 0
Fetch 2490024 100.17 112.70 2243 4419966 0 248837670
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2494359 100.24 112.77 2243 4419966 0 248837670



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