This content has been marked as final. Show 4 replies
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.
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.