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 (with 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 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. |