Solving a 10g Bind Variable Peeking problem by granting and revoking privileges
- Posted by Gavin Soorma
- On August 23, 2010
- 0 Comments
The Cost Based optimizer peeks at the values of user-defined bind variables on the first invocation of a cursor. Based on this, the optimizer determines the selectivity of the WHERE clause condition as if literals have been used instead of bind variables. On subsequent invocations of the cursor, no bind peeking takes place, and the […]
Read More