Oracle教程 2023-03-31

Oracle 参数 CURSOR_BIND_CAPTURE_DESTINATION 官方解释，作用，如何配置最优化建议

CURSOR_BIND_CAPTURE_DESTINATION：此参数控制SQL引擎（运行模式）是否在与bind value关联的lob值存储位置中检索要应用于bind变量的值（或其长度）。

设置方法：

1、在客户端会话中：
ALTER SYSTEM SET CURSOR_BIND_CAPTURE_DESTINATION=value

2、通过参数文件：
CURSOR_BIND_CAPTURE_DESTINATION=value

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

Property	Description
Parameter type	String
Syntax	`CURSOR_BIND_CAPTURE_DESTINATION = { off \| memory \| memory+disk }`
Default value	`memory+disk`
Modifiable	`ALTER` `SESSION`, `ALTER` `SYSTEM`
Modifiable in a PDB	Yes
Basic	No

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";
```

分享到：