My Oracle Support Banner

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

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.