Assignment Manager Performance
(Doc ID 545041.1)
Last updated on JANUARY 31, 2022
Applies to:Siebel Assignment Manager - Version 126.96.36.199 SIA  and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 188.8.131.52  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