My Oracle Support Banner

Slow performance for Siebel Select with a Subquery. (Doc ID 500165.1)

Last updated on APRIL 30, 2018

Applies to:

Siebel Tools - Version 7.7.2.3 SIA [18361] to 8.2.2 SIA[22320] [Release V7 to V8]
IBM AIX on POWER Systems (64-bit)
Product Release: V7 (Enterprise)
Version: 7.7.2.3 [18361] Fin Svcs
Database: Oracle 9.2.0.6
Application Server OS: IBM AIX 5L 5.2
Database Server OS: IBM AIX 5L 5.2
Reviewed for relevance 29-MAR-2013.
This document was previously published as Siebel SR 38-2983797391.
Reviewed for relevance "05-FEB-2016".

Symptoms

We have poorly performing queries on custom applets. Is there any way to override the Optimizer_mode=FIRST_ROWS_10 setting in the data connector or to ensure the *all row* hint described in TechNote 582 is used?

The queries work well thru an sql client but poorly from within Siebel. Setting ALTER SESSION SET OPTIMIZER_MODE = FIRST_ROWS_10 within the sql client replicates the poor performance seen within Siebel.

Thanks!

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
References

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.