Excessive I/O On S_BCSTMSG_USER Table
Last updated on JULY 11, 2018
Applies to:Siebel CRM - Version 18.104.22.168.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?
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