Purpose
GV$DBLINK displays all DBLinks (the links with IN_TRANSACTION set to YES) opened by the session issuing the query on this view. These DBLinks must be committed or rolled back before being closed.
Fields
| Field | 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: |
| 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 type of character sets supported by the OCI link. |
| OCI_ENV_NCHARSET | NUMBER(38) | NO | The type of national character sets supported by the OCI link. |
| EXTRA_INFO | VARCHAR2(32767) | YES | The additional information about the database link. |