Table S_CM_MSG_STAT full resulting in Comm Outbound Manager Delivering Emails Slowly
Last updated on MARCH 02, 2017
Applies to:Siebel Email Response - Version 184.108.40.206  and later
Information in this document applies to any platform.
On Siebel 220.127.116.11 enterprise application (call-center) customer using Siebel outbound communications for sending several outbound emails through workflow policies, eMail manager, eMail response, F9, etc.
Recently it was found that there was a performance deterioration in outbound communications - emails being sent by the Communication Outbound Manager.
Upon investigating we found Communication outbound manager tasks are blocking each other, with wait type PAGELATCH_UP and taking some time to clear these blocks on the database and causing delaying in outbound communications. These locks are due to the following query that communications outbound manager is using.
CONVERT (VARCHAR (10),T1.LAST_UPD, 101) + ' ' + CONVERT (VARCHAR (10),T1.LAST_UPD, 8),
CONVERT (VARCHAR (10),T1.CREATED, 101) + ' ' + CONVERT (VARCHAR (10),T1.CREATED, 8),
OPTION (FAST 40)
We are wondering how these records are creating into this table and we can see per day approximately 10,000 records creating into this table and we do not see any triggers on this table against policies Campaign Offer Message Tracking – Delivered and Campaign Offer Message Tracking – Failed.
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