Excessive I/O On S_BCSTMSG_USER Table

(Doc ID 2421755.1)

Last updated on JULY 11, 2018

Applies to:

Siebel CRM - Version 8.1.1.14.18 [IP2014] and later
Information in this document applies to any platform.

Goal

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?

Solution

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