Assignment Manager Performance (Doc ID 545041.1)

Last updated on MAY 16, 2016

Applies to:

Siebel Assignment Manager - Version 7.8.2.6 SIA [19230] and later
z*OBSOLETE: Microsoft Windows Server 2003
**Checked for relevance on 16-MAY-2016**
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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms