Siebel Administration Generating Execution Plans for Oracle CBO (Doc ID 475230.1)

Last updated on MAY 31, 2023

Applies to:

Siebel System Software - Version 7.7.2 [18325] to 16.0 [IP2016] [Release V7 to V16]
Information in this document applies to any platform.

Purpose

Starting with Siebel version 7.7, if using Oracle9i or above, the Database Server must run with Cost-Based Optimizer (CBO).

The way an Application Object Manager (AOM) works with Oracle CBO is a bit different from the Rule-Based Optimizer (RBO) approach, so there are some steps to follow in order to get an accurate Execution Plan.

Scope

This document is informational and intended for any user.

When using Oracle CBO, a Siebel AOM sets some database parameters at session level which influence the behavior of the Optimizer when parsing a SQL statement, and makes use of Bind Variables in order to take advantage of SQL sharing.

This is considered by the CBO when determining the best Execution Plan for each statement, and must be taken into consideration when tuning the performance of a SQL statement, so that you can see the exact access path used by Oracle within a Siebel session.