Update Of Master Items With Template Taking A Very Long Time To Save (Doc ID 737036.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Installed Base - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 19-May-2014***

Symptoms

-- Problem Statement:
When trying to change the master item using a template it takes long time to save.

-- Steps To Reproduce:
1. Oracle inventory->Master items
2. Enter query mode (F11)
3. Enter the item code of the item to be updated
4. Tools->copy->template name which needs to be applied on the item
5. Click Done
6. Click Save

It takes about 20-25 min to save and some times even more.

The following expensive script has been shown in the trace.

SELECT MSG_ID, MSG_CODE, MSG_STATUS, BODY_TEXT, CREATION_DATE, DESCRIPTION
FROM
XNP_MSGS WHERE (MSG_CODE LIKE 'CSI%' OR MSG_CODE LIKE 'CSE%') AND MSG_STATUS
IN ('READY','FAILED') AND MSG_CREATION_DATE > :B1 AND RECIPIENT_NAME IS  NULL


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 3 0.00 0.00 0 0 10 0
Execute 3 0.23 0.25 0 0 0 0
Fetch 1449 95.18 2161.91 194973 197322 0 144900
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1455 95.41 2162.18 194973 197322 10 144900

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