Performance on Account Merge When Audit Trail is On (Doc ID 2086915.1)

Last updated on AUGUST 17, 2022

Applies to:

Symptoms

On :  8.1.1.11.14 [IP2013] version, following is observed:

ACTUAL BEHAVIOR  
---------------

Upon analyzing the sql statements, customer indicated that the sql below is taking ~3 minutes.
UPDATE SIEBEL.S_SRV_REQ SET  MODIFICATION_NUM = MODIFICATION_NUM + 1,
      LAST_UPD = ?,
      LAST_UPD_BY = ?,
      DB_LAST_UPD_SRC = ?,
      DB_LAST_UPD = current utc timestamp
WHERE ROW_ID IN (SELECT ROW_ID FROM  SIEBEL.S_SRV_REQ1_FNX
   WHERE AF_INS_COMPANY_ID = ?
   )


EXPECTED BEHAVIOR
-----------------------
Account merge should take less time

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Launch eCommunications for hi-tech industry in Open UI
2. Perform a merge on Account

Result: When the auditing is on Account,  merge transactions are  taking  ~4 minutes whereas as it takes ~40 seconds without auditing on Service request.

Changes

Cause

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