Slow Processing for Inbound and Outbound Emails Due Slow Query on S_COMM_REQ or S_COMM_REQ_PKG Tables

(Doc ID 537987.1)

Last updated on JANUARY 01, 2017

Applies to:

Siebel Email Response - Version SIA [18385] to [IP2013] [Release V7 to V8]
All Platforms


When CommOutboundManager component launch more than one Tasks (5 or 10) it impacts the overall Siebel Database performance leading to bad performance of Siebel Application.

The CommOutboundManager is executing a query on S_COMM_REQ for example that takes up to 1 minute to be executed.

       SIEBEL.S_USER T1,
      T2.CREATED_BY = T1.PAR_ROW_ID (+)

The Table S_COMM_REQ has couple of million records most of them with Status: "Done".

Similar performance problems can be observed on table S_COMM_REQ_PKG that also has couple of millions records.


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