Purpose
V$DBLINK displays all DBLinks (the links with IN_TRANSACTION set to YES) opened by the session that issues the query on this view. These DBLinks must be committed or rolled back before they are closed.
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. |