What Is Siebel table S_CM_MSG_STAT Used For? (Doc ID 1590839.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 7.8 [19021] and later
Information in this document applies to any platform.
This table is building up and seems to be recording outbound requests that are successful. It seems that on certain period, there's little to none number of records being created in this table while other dates there are thousands. We trace these records back to the comm_req_src and see that the outbound request was sucessful. We think that it is not just writing "Failed" ones but also "Sucessful" ones. Thus with the table growing to 2mil records now, the below SQL that we see in the AWR is performance impact to our application.

SELECT T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID
FROM SIEBEL.S_CM_MSG_STAT T1 ORDER BY T1.OBJECT_TYPE_CD, T1.SEND_TS

Could you please help us find out why these all these records are being written to the table and if there's any impact if we just truncate thei table so that we could get our application performance back to normal.

Symptoms

 This table is building up and seems to be recording outbound requests that are successful. It seems that on certain period, there's little to none number of records being created in this table while other dates there are thousands.

Changes

 none

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