Slow Query Performance (Doc ID 530105.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 7.7.2.5 [18368] to 8.2.2 SIA[22320] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.7.2.5 [18368]
Database: Oracle 10.1.0.2
Application Server OS: Microsoft Windows 2000 Server SP 4
Database Server OS: Sun Solaris 2.8

This document was previously published as Siebel SR 38-3098027535.

Checked for Relevance on ***Jun 5th 2014**

Checked for Relevance on ** Jan 21st 2016**

Symptoms

Customer  have upgraded from Siebel 6.3 to 7.7.2.5.
Performing query on "Order #" with applet search specification "[Order Type] = LookupValue ('FS_ORDER_TYPE', 'Sales Order') OR [Order Type] = LookupValue ('FS_ORDER_TYPE', 'eSales Order')" takes 11 minutes for execution.

But when query on other fields(other than Order #) with same applet search specification execution time is less than 2 seconds.

If search specification on Applets is removed, query on Order # execution time is 5 seconds.

For better understanding, two log files have been attached.
1) Query on Order # with search spec - "with search spec - 5.344 seconds.txt"
2) Query on Order # without search spec - "without search spec - 658.814 seconds.txt"

Objects used
Bus Comp - "Order Entry - Orders"
Applets - "Order Entry - Order List Applet (Sales)", "Order Entry - Order Form Applet - Entry (Sales)"

How to improve performance for execution of query on order # with applet search spec?

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