My Oracle Support Banner

Performance Issue With "Interface Install Base Lines" Concurrent Program (Doc ID 2616081.1)

Last updated on JUNE 25, 2021

Applies to:

Oracle Installed Base - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

Performance issue with "Interface Install Base Lines" Concurrent Program

Expensive SQL found as following

 

UPDATE CSI_CUSTIB_OM_TREE_TMP EO SET (PARENT_TEMP_INSTANCE_ID,
 ASSEMBLY_ITEM_ID,LINK_TO_LINE_ID)= (SELECT TEMP_INSTANCE_ID,
 INVENTORY_ITEM_ID,ORDER_LINE_ID FROM CSI_CUSTIB_OM_TREE_TMP O
WHERE
TREE_ID=:B2 AND TREE_INSTANCE_ID=:B1 AND ITEM_TYPE_CODE = 'CONFIG' AND
 EXISTS (SELECT 1 FROM CSI_CUSTIB_OM_TREE_TMP WHERE ITEM_TYPE_CODE='CLASS'
 AND ORDER_LINE_ID=O.LINK_TO_LINE_ID AND ORDER_LINE_ID=EO.LINK_TO_LINE_ID
 AND TREE_ID=:B2 AND TREE_INSTANCE_ID=:B1 ) ) WHERE ORDER_LINE_ID=:B3 AND
 TREE_ID=:B2 AND TREE_INSTANCE_ID=:B1 AND ITEM_TYPE_CODE <> 'CONFIG' AND
 LINK_TO_LINE_ID IN (SELECT ORDER_LINE_ID FROM CSI_CUSTIB_OM_TREE_TMP IO
 WHERE ITEM_TYPE_CODE='CLASS' AND TREE_ID=:B2 AND TREE_INSTANCE_ID=:B1 AND
 EXISTS (SELECT 1 FROM CSI_CUSTIB_OM_TREE_TMP WHERE LINK_TO_LINE_ID=
 IO.ORDER_LINE_ID AND ITEM_TYPE_CODE = 'CONFIG' AND TREE_ID=:B2 AND
 TREE_INSTANCE_ID=:B1 ) )

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.