Applies to:Siebel Applications - Version: 8.0  and later [Release: V8 and later ]
Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 22.214.171.124 [Release: 10.2 to 11.2]
Information in this document applies to any platform.
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.