CURSOR_BIND_CAPTURE_DESTINATION

Property	Description
Parameter type	String
Syntax	`CURSOR_BIND_CAPTURE_DESTINATION = { off \| memory \| memory+disk }`
Default value	`memory+disk`
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).

Note:
The CURSOR_BIND_CAPTURE_DESTINATION initialization parameter is available starting with Oracle Database 11g Release 2 (11.2.0.2).