My Oracle Support Banner

A Siebel Query with a Subquery is very Slow in an Oracle CBO Siebel Environment. The Slow Performance was improved by using the Hidden init.ora parameter "_always_semi_join". (Doc ID 511886.1)

Last updated on FEBRUARY 02, 2022

Applies to:

Siebel CRM - Version 7.7.2 [18325] and later
Siebel Tools - Version 7.7.2 SIA [18325] to SIA [21225] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise), V8 (Enterprise)
Version: 7.7.2 [18325] Fin Svcs to SIA [21225]
Database: Oracle 9i
Application Server OS: Microsoft Windows 2003 Server
Database Server OS: IBM AIX 5L 5.1

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



 Performance problems are observed within the system. A certain query is taking, on average, 7 minutes to be returned. The DBA has run that query exactly as it came out of Siebel using the bind variables within a script. That script ran in seconds. It appears as though, when running from the system, there is a very large timeframe for gaps with no activity and waited idle time. The amount of time spent at the database level is minimal. . 


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.