CURSOR_BIND_CAPTURE_DESTINATION


Property Description

Parameter type

String

Syntax

CURSOR_BIND_CAPTURE_DESTINATION = { off | memory | memory+disk }

Default value

NULL

Modifiable

ALTER SESSION, ALTER SYSTEM

Basic

No


CURSOR_BIND_CAPTURE_DESTINATION determines the location at which bind variables that are captured from SQL cursors are available.

Values

  • off

    Bind variables are not captured from SQL cursors.

  • memory

    Bind variables are captured from SQL cursors, and are available only in memory (V$ views).

  • memory+disk

    Bind variables are captured from SQL cursors, and are available in memory (V$ views) and disk (Automatic Workload Repository tables, SQL Tuning Set tables, and so on).

    When you specify this value with a SQL ALTER SESSION or ALTER SYSTEM statement, enclose the value in single quotes or double quotes. For example:

    ALTER SESSION SET CURSOR_BIND_CAPTURE_DESTINATION = 'memory+disk';
    ALTER SYSTEM SET CURSOR_BIND_CAPTURE_DESTINATION = "memory+disk";