1. Database Reference
  2. Dynamic Performance Views
  3. Dynamic Performance (V$) Views: V$SCHEDULER_RUNNING_JOBS to V$ZONEMAP_USAGE_STATS
  4. V$SQL_SHARD

9.63 V$SQL_SHARD

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