Recent site activity


Oracle Seminar Demo Scripts

SQL Execution

 bind_peeking_nested_loops.sqlThis script demonstrates how wrong bind variable values used for bind variable peeking can compile an inefficient execution plan for next bind variable values used. This query will take very long time to run the 2nd execution due nested looping over large number of rows and even the adaptive bind peeking feature (Oracle 11.1+) does not help the first time the problem happens.