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

Last updated on MARCH 02, 2017

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

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