Purpose
The V$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 |
|---|---|---|---|
| DB_LINK | VARCHAR2(128) | NO | The name of the DBLink. |
| OWNER_ID | NUMBER | NO | The owner of the DBLink UID. |
| LOGGED_ON | VARCHAR2(3) | NO | Indicates whether the DBLink is logged on. |
| HETEROGENEOUS | VARCHAR2(3) | NO | Indicates whether the database accessed by the DBLink is heterogeneous. |
| PROTOCOL | VARCHAR2(6) | NO | The communication protocol for the DBLink. 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 | NO | Indicates whether the DBLink has open cursors. |
| IN_TRANSACTION | VARCHAR2(3) | NO | Indicates whether the DBLink is in a transaction. |
| UPDATE_SENT | VARCHAR2(3) | NO | Indicates whether the DBLink is updated. |
| COMMIT_POINT_STRENGTH | NUMBER | NO | The commit point strength of the transactions on the DBLink. |
| CON_ID | NUMBER | NO | The ID of the tenant that creates the DBLink. |