What Is Siebel table S_CM_MSG_STAT Used For?
(Doc ID 1590839.1)
Last updated on MARCH 12, 2021
Applies to:Siebel CRM - Version 7.0.4 SIS  to 20.1 [Release V7 to V17]
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.
S_CM_MSG_STAT is recording outbound requests that are successfull. The table size is increasing as it is recording all the successful requests.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document