Oracle教程

Oracle 视图 V$SQL_SHARD 官方解释，作用，如何使用详细说明

本站中文解释

_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_ID

VARCHAR2(13)

SQL identifier of a cross shard query on the coordinator

CHILD_NUMBER

NUMBER

Cursor child number of a cross shard query on the coordinator

OPERATION_ID

NUMBER

Operation ID of a remote node for a shard SQL fragment of a cross shard query

SHARD_SQL_ID

VARCHAR2(13)

SQL ID of the SQL segment associated with a remote operation identified by the operation ID in the OPERATION_ID column

SHARD_ID

NUMBER

IDs of shards where the shard SQL fragment was executed

SHARD_CHILD_NUMBER

NUMBER

Cursor child number of a shard SQL fragment on a shard. The default value is 0.

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data


数据运维技术 » Oracle 视图 V$SQL_SHARD 官方解释，作用，如何使用详细说明
分享到：

相关推荐