Skip to content

Month: June 2011

Cursor Sharing

Sharing Cursors

Values for CURSOR_SHARING are:

  • EXACT (default)
    • SQL statements must be identical to share cursors.
  • SIMILAR
    • SQL statements that are similar share cursors, provided that their respective execution plans are the same.
  • FORCE
    • SQL statements that are similar share cursors regardless of the impact on the execution plan. Bind peeking is done on the first parse, and possibly later due to adaptive cursor sharing (11g).

SIMILAR statements are identical except for the values of some literals.