Slow Processing for Inbound and Outbound Emails Due Slow Query on S_COMM_REQ or S_COMM_REQ_PKG Tables
Last updated on JANUARY 01, 2017
Applies to:Siebel Email Response - Version 184.108.40.206 SIA  to 220.127.116.11.15 [IP2013] [Release V7 to V8]
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.
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
Million Knowledge Articles and hundreds of Community platforms