Property | Description |
---|---|
Parameter type |
String |
Syntax |
|
Default value |
|
Modifiable |
|
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";