My Oracle Support Banner

Query Performance (Doc ID 1472592.1)

Last updated on FEBRUARY 10, 2019

Applies to:

Siebel CRM - Version 8.0 SIA [20405] and later
Information in this document applies to any platform.
***Checked for relevance on 5-SEP-2012***
***Checked for Relevance on 03-AUG-2014 ***


Customer was upgrading from siebel to siebel and the new database is oracle 11gR2.
During the performance testing, some predefined queries have much longer run time in siebel 8. This query went from 4 seconds in Siebel 7 to 12 seconds in Siebel 8.

The siebel 8 trace file is showing the query is doing several binds and having a lot more logical reads than the same query in Siebel 7.

Customer wanted to know the following:

  1. Why does siebel 8 perform the bind several times? Based on the trace file, looks like at least 6 seconds were lost in the bind. Siebel 7 trace file showed only 1 bind.
    Is there any way siebel 8 can be changed to do the binding only once?
  2. Why does the query in Siebel 8 need 1893514 logical reads while the same query in siebel needed only 684709 logical reads? (The two databases have about the same volume of data)
  3. There is a defect for bind peeking degradation [10596842]. Is it still a defect in Is there anything we need to change in the environment to improve performance?
  4. Is there anything else we need to change in our environment?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.