Name
CURSOR_SHARING
Synopsis
Value: SIMILAR | EXACT | FORCE
Dynamic: ALTER SYSTEM, ALTER SESSION
Specifies the way that SQL statements can share cursors in memory. New with Oracle9i.
Keywords
- SIMILAR
Specifies that SQL that is the same except for literals will share the same cursor in memory unless the literals affect the meaning of the SQL statement.
- EXACT
Specifies that SQL must be identical to share the same cursor in memory.
- FORCE
Specifies that SQL that is the same except for literals will share the same cursor.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.