Note
This view is not supported. To view the created DBLink, use DBA_DB_LINKS, ALL_DB_LINKS, or USER_DB_LINKS.
Purpose
This view displays all database links opened after a query session is started on this node (IN_TRANSACTION=YES). These database links must be committed or rolled back before they are closed.
Applicability
This view is applicable only to OceanBase Database in Oracle 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 an update. |
| 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. |