Note
This view is not supported. To view the created DBLink, use the DBA_DB_LINKS, ALL_DB_LINKS, and USER_DB_LINKS views.
Purpose
This view displays all database links (IN_TRANSACTION=YES) opened after a query session is started on the current node. These database links must be committed or rolled back before they are closed.
Applicability
This view is applicable only to OceanBase Database in Oracle-compatible mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| DB_LINK | VARCHAR2(128) | NO | The name of the database link. |
| OWNER_ID | NUMBER | NO | The owner of the UID of the database link. |
| LOGGED_ON | VARCHAR2(3) | NO | Indicates whether the database link is logged on. |
| HETEROGENEOUS | VARCHAR2(3) | NO | Indicates whether the database accessed by the database link is heterogeneous. |
| PROTOCOL | VARCHAR2(6) | NO | The communication protocol of the database link:
|
| OPEN_CURSORS | NUMBER | NO | Indicates whether the database link has an open cursor. |
| IN_TRANSACTION | VARCHAR2(3) | NO | Indicates whether the database link is in a transaction. |
| UPDATE_SENT | VARCHAR2(3) | NO | Indicates whether the database link has updates. |
| COMMIT_POINT_STRENGTH | NUMBER | NO | The commit point strength of the transaction on the database link. |
| CON_ID | NUMBER | NO | The tenant ID that created the database link. |