Assignment Manager Performance
(Doc ID 545041.1)
Last updated on JANUARY 17, 2020
Applies to:Siebel Assignment Manager - Version 18.104.22.168 SIA  and later
z*OBSOLETE: Microsoft Windows Server 2003
**Checked for relevance on 16-MAY-2016**
Product Release: V7 (Enterprise)
Version: 22.214.171.124  Hi Tech
Database: Oracle 10.2.0.2
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: Red Hat Linux 4.0
This document was previously published as Siebel SR 38-3424387501.
We have defined Workload distribution rules for Activities based on the out of the box "Activity Status" Assignment Attribute. We want the workload distribution rule to consider only "Open Activities". We performed a trace and found the poor performance resides with the following statement
SQLSlowQuery Statement 4 0 2007-08-09 01:21:07 SELECT COUNT(*)
FROM SIEBEL.S_EVT_ACT T0 ,
T0.EVT_STAT_CD = 'Open' AND
T12.EMP_ID = ? AND
T0.ROW_ID <> ? AND
T12.ACTIVITY_ID = T0.ROW_ID
SQLSlowQuery Bind Variables 4 0 2007-08-09 01:21:07 01:1-9HF-391
Can you suggest an alternative to improve performance?
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