My Oracle Support Banner

Assignment Manager Performance (Doc ID 545041.1)

Last updated on JANUARY 31, 2022

Applies to:

Siebel Assignment Manager - Version SIA [19230] and later
z*OBSOLETE: Microsoft Windows Server 2003 Product Release: V7 (Enterprise)
Version: [19230] Hi Tech
Database: Oracle
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 ,
        SIEBEL.S_ACT_EMP T12
            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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.