• Database

    11g, Sherlock Holming it with Statistics, Histograms and Bind Peeking

    Yes, my dear Watson, Bind Peeking is still an issue in 11g…. We recently upgraded from 10.2.0.4 to 11.2.0.2.0 and come across a couple interesting performance challenges. I do like this type of problem and have been quite busy working on the fixes for each one that has shown itself. This was one of the latest, requiring a solid, positive relationship between the developer and the DBA to solve- The DBA may have the answer, but the developer must be comfortable with the solution and make the code/design change that is required to correct the issue. I do work with…