First page Back Continue Last page Overview Graphics
Continuation of Notes
This is a full page of notes.
The slide is hidden.
Notes:
If I override my session to CURSOR_SHARING=EXACT, note that the bind variable is not introduced:
SQL> alter session set cursor_sharing=exact;
Session altered.
SQL> select /*1209*/ cust_no
2 from t
3 where lastname = 'OWA'
SQL> /
CUST_NO
----------
63110
SQL> @v$sql_plan '1209'
SQL_TEXT
------------------------------------------------------
select /*1209*/ cust_no from t where lastname = 'OWA'
Note that the script used in this example V$SQL_PLAN.SQL is a supplied script.
You may also want to search the asktom.oracle.com site for “cursor_sharing similar” for additional detailed examples.