First page Back Continue Last page Overview Graphics

…Cursor Sharing

CURSOR_SHARING_EXACT hint
- Overrides CURSOR_SHARING=SIMILAR | FORCE

Notes:

The CURSOR_SHARING_EXACT hint turns off the cursor sharing feature.

As with the ALTER SESSION command that we executed earlier, the CURSOR_SHARING_EXACT hint does not use a bind variable.

SQL> @v$sql_plan ‘CURSOR_SHARING_EXACT’

SQL_TEXT
---------------------------------------------------------
SELECT /*+ CURSOR_SHARING_EXACT */ cust_no FROM t WHERE lastname = 'OWA'