My Oracle Support Banner

Excessive I/O On S_BCSTMSG_USER Table (Doc ID 2421755.1)

Last updated on JULY 16, 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

To view full details, 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 a vibrant support community of peers and Oracle experts.