In the previous chapter, we have explored the (recommended) use of bind variables.
In this recipe, we will see how using bind variables can be disadvantageous in certain situations and learn about a feature of Oracle Database 11g that helps us with this.
The following steps will demonstrate Adaptive Cursor Sharing:
IDthat equals 1:
CREATE TABLE sh.MY_TEST AS SELECT OBJECT_NAME AS NAME, 1 AS ID FROM ALL_OBJECTS NOLOGGING;
INSERT INTO sh.MY_TEST (ID, NAME) VALUES (2, 'ONLY THIS RECORD HAS ID=2'); INSERT INTO sh.MY_TEST (ID, NAME) VALUES ...