Need to reduce deletes on S_SRM_REQUEST table
Last updated on JULY 11, 2017
Applies to:Siebel System Software - Version 184.108.40.206 SIA  and later
z*OBSOLETE: Microsoft Windows 2000
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms