DBA Kevlar

Tips, tricks, (and maybe a few rants) so more DBAs become bulletproof!

February 4th, 2010

Dealing with Bind Variable Peeking

Tanel Poder had a great post about bind variable peeking, http://blog.tanelpoder.com/2010/02/02/bind-variable-peeking-execution-plan-inefficiency/  I run into this exact issue more often than I would like to and have found a few tricks to refrain it from happening in code that is “vulnerable” to the situation. Truthfully, there isn’t much you can do when Oracle has gone in […]

 

  • Facebook
  • Google+
  • LinkedIn
  • Twitter