This discussion is archived
4 Replies Latest reply: Apr 19, 2012 7:14 AM by 883997 RSS

SIEBEL_ORA_BIND_PEEK variable

Penky Journeyer
Currently Being Moderated
Hi All,

I read a lot about this system variable and that it may affect performance. Depending on fixpack version one should either set it to true, or false. Siebel Performance Tuning Guide recommends setting it to false. But what exactly does it do? Can anyone explain it what it does and why it may affect performance?

Thank you!
  • 1. Re: SIEBEL_ORA_BIND_PEEK variable
    WSiebel Pro
    Currently Being Moderated
    Penky,

    Please check if doc Doc ID 781927.1 on support.oracle.com can be helpful, mainly section "Peeking of User Binds in Siebel CRM" in this document.

    Thanks,

    Wilson
  • 2. Re: SIEBEL_ORA_BIND_PEEK variable
    915392 Newbie
    Currently Being Moderated
    Without this variable siebel was not resuing SQL code, execution plan etc. from memory, but it was hard-parsing (full analysis of SQL) everytime.
    Mostly with LIKE in SQL statement.
  • 3. Re: SIEBEL_ORA_BIND_PEEK variable
    Penky Journeyer
    Currently Being Moderated
    Hi and thanks for the document. I already knew this doc, but in my opinion it's not clear what they mean. For example in this doc it says

    "It is recommended that Siebel CRM customers deploy a Fix Pack or Quick Fix for their base application version, and leverage the environment variable SIEBEL_ORA_BIND_PEEK to enable or disable bind peeking based on their requirements. The recommended setting is FALSE."

    I tried both versions (True and False) and had a look at the SQL statements in Siebel Log files. In both cases, bind variables were used so I could not see any great difference.
    Anyway, thanks for you help.
  • 4. Re: SIEBEL_ORA_BIND_PEEK variable
    883997 Newbie
    Currently Being Moderated
    Penky,

    Bind variables will be used, regardless of the value for SIEBEL_ORA_BIND_PEEK (it seems that you are confusing this with the use of literals). The SIEBEL_ORA_BIND_PEEK is intended for enabling or disabling bind peeking, and does not mean that bind variables would be replaced by literals.


    Regards,

    Roland

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points