My Oracle Support Banner

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

Last updated on APRIL 01, 2019

Applies to:

Siebel CRM - Version [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!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.