bind peeking in Oracle Siebel

Siebel Bind peeking performance degradation future enhancement [ID 1273535.1]

Applies to:

Siebel Applications - Version: 8.0 [20405] and later   [Release: V8 and later ]
Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.2.0.2   [Release: 10.2 to 11.2]
Information in this document applies to any platform.

Description

This document applies specifically to Siebel applications.

Oracle is introducing a change specifically for the Siebel application that will eliminate the requirement for the SIEBEL_ORA_BIND_PEEK variable setting. This change will reduce hard-parsing to only a single one when the SQL statement is first processed. Subsequent executions of the same statement (with the same or different bind values) will not generate more hard-parsing. Other improvements are included to further enhance SQL performance, which will be explained in detail when the fix becomes available.

Parent bug 10596842 has been logged to address this Product Defect.

Patches

This fix will be included in Fix Packs targeted for mid-2011 and subsequent major releases of Siebel CRM for Oracle 10g and 11g, and will be available on all supported OS platforms for Siebel CRM.