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 JUNE 27, 2018
Applies to:Siebel Email Response - Version 18.104.22.168 SIA  to 22.214.171.124.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.
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