Feature
This view displays all database links (the links with IN_TRANSACTION set to YES) opened by the session that issues the query on this view. These database links 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 MySQL mode.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| DB_LINK | VARCHAR2(128) | NO | The name of the database link. |
| OWNER_ID | NUMBER | NO | The owner of the database link UID. |
| 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 for the database link. Valid values: |
| OPEN_CURSORS | NUMBER | NO | Indicates whether the database link has open cursors. |
| IN_TRANSACTION | VARCHAR2(3) | NO | Indicates whether the database link is in a transaction. |
| UPDATE_SENT | VARCHAR2(3) | NO | Indicates whether the database link is updated. |
| COMMIT_POINT_STRENGTH | NUMBER | NO | The commit point strength of the transactions on the database link. |
| CON_ID | NUMBER | NO | The ID of the tenant that creates the database link. |