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 (links with IN_TRANSACTION=YES) opened after the query session on the view is initiated. The database links must be committed or rolled back before they are closed.
Applicability
This view is available only in Oracle mode of OceanBase Database.
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 in. |
| 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 of the database link. |