Assignment Manager Performance
(Doc ID 545041.1)
Last updated on JANUARY 31, 2022
Applies to:
Siebel Assignment Manager - Version 7.8.2.6 SIA [19230] and laterz*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.8.2.6 [19230] 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.
Symptoms
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 ,
SIEBEL.S_ACT_EMP T12
WHERE
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
02:1-8LKT3
Can you suggest an alternative to improve performance?
Cause
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
Symptoms |
Cause |
Solution |