Purpose
The GV$DBLINK view displays all DBLinks (the links with IN_TRANSACTION set to YES) opened by the session that issues the query on this view. These DBLinks must be committed or rolled back before they are closed.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The ID of the tenant. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the remote database. |
| SVR_PORT | NUMBER(38) | NO | The port number of the remote database. |
| LINK_ID | NUMBER(38) | NO | The ID of the database link. |
| LOGGED_ON | NUMBER(38) | NO | Indicates whether the database link is logged on. |
| HETEROGENEOUS | NUMBER(38) | NO | Indicates whether the database accessed by the database link is heterogeneous. |
| PROTOCOL | NUMBER(38) | NO | The communication protocol for the database link. Valid values:OceanBase: The internal protocol of OceanBase Database is used to access OceanBase Database in Oracle mode.OCI: The Oracle Call Interface (OCI) library is used to access Oracle Database. |
| OPEN_CURSORS | NUMBER(38) | NO | Indicates whether the database link has open cursors. |
| IN_TRANSACTION | NUMBER(38) | NO | Indicates whether the database link is in a transaction. |
| UPDATE_SENT | NUMBER(38) | NO | Indicates whether the database link is updated. |
| COMMIT_POINT_STRENGTH | NUMBER(38) | NO | The commit point strength of the transactions on the database link. |
| LINK_TENANT_ID | NUMBER(38) | NO | The ID of the tenant that creates the database link. |
| OCI_CONN_OPENED | NUMBER(38) | NO | The number of connections opened on the OCI link. |
| OCI_CONN_CLOSED | NUMBER(38) | NO | The number of connections closed on the OCI link. |
| OCI_STMT_QUERIED | NUMBER(38) | NO | The number of SQL queries on the OCI link. |
| OCI_ENV_CHARSET | NUMBER(38) | NO | The character sets supported by the OCI link. |
| OCI_ENV_NCHARSET | NUMBER(38) | NO | The national character sets supported by the OCI link. |
| EXTRA_INFO | VARCHAR2(32767) | YES | The additional information about the database link. |