Excessive I/O On S_BCSTMSG_USER Table
(Doc ID 2421755.1)
Last updated on JULY 16, 2018
Applies to:Siebel CRM - Version 22.214.171.124.18 [IP2014] and later
Information in this document applies to any platform.
SQL GENERATED BY MESSAGE BROADCAST IS CAUSING HIGH CPU UTILIZATION. It was just a SQL with poor performance but now, as the number of users increase, the the SQLs generated by Message Broadcasting are causing a severe impact on production database. We already run EIM job to delete old records from the S_BRDCST_MSG table to keep only the messages from the last 7 days. How to reduce performance impact due to MESSAGE BROADCAST functionality?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!