Bind peeking means, oracle uses the same execution plan which is already stored in the LC(Library Cache). This execution plan may be an inefficient execution plan for a different value(300 in our example).
To overcome this problem oracle has introduced "adaptive cursor sharing" in 11g. In this case, oracle generates multiple execution plans and picks the optional execution plans.
