国外主机测评 - 国外VPS，国外服务器，国外云服务器，测评及优惠码
本站中文解释
_CURSION及用途
Oracle视图V$SQL_SHARD_CURSION用于显示用户会话中正在运行的片段缓冲游标的详细信息。
此视图存储类似SQL语句片段的附加信息，并提供精细控制与调优。通过此视图，可以查询当前在使用片段缓冲游标的会话以及该会话正在使用的片段缓冲游标上下文。
该视图包括会话ID、片段缓冲游标类型、片段缓冲游标上下文对象、片段缓冲游标ID、片段缓冲游标的分组大小及片段缓冲游标的绑定变量等信息。
例如，要查询某一会话中使用的片段缓冲游标信息，可使用以下SQL语句：
SELECT *
FROM V$SQL_SHARD_CURSOR
WHERE Sid = &sid;
官方英文解释
V$SQL_SHARD displays the shard information for a shard query’s previous execution. This view uniquely maps a shard SQL fragment of a cross shard query to the target shard database.
| Column | Datatype | Description |
|---|---|---|
|
|
|
SQL identifier of a cross shard query on the coordinator |
|
|
|
Cursor child number of a cross shard query on the coordinator |
|
|
|
Operation ID of a remote node for a shard SQL fragment of a cross shard query |
|
|
|
SQL ID of the SQL segment associated with a remote operation identified by the operation ID in the |
|
|
|
IDs of shards where the shard SQL fragment was executed |
|
|
|
Cursor child number of a shard SQL fragment on a shard. The default value is |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
