Need to reduce deletes on S_SRM_REQUEST table (Doc ID 535024.1)

Last updated on JULY 11, 2017

Applies to:

Siebel System Software - Version 7.7.2.5 SIA [18368] and later
z*OBSOLETE: Microsoft Windows 2000

Symptoms

How to stop the cleanup of the S_SRM_REQUEST table running every 5 minutes on their three servers, and to run every 8 hours instead.

It was noticed that the below SQL is frequently (5 to 10 minutes I guess) ran on all 3 servers:


SELECT T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.ACTION_ID FROM siebel.S_SRM_REQUEST T1 INNER JOIN siebel.S_LST_OF_VAL T2 ON T1.STATUS = T2.NAME AND T2.TYPE = 'SRM_STATUS' AND T2.LANG_ID = ?
WHERE (T2.VAL = ? AND T1.EXPIRATION_DT < CAST(? AS TIMESTAMP))
ORDER BY T1.TGT_DELETE_TS
FOR FETCH ONLY OPTIMIZE FOR 1 ROW



Changes

 

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