V$DBLINK describes all database links (links with IN_TRANSACTION = YES) opened by the session issuing the query on V$DBLINK. These database links must be committed or rolled back before being closed.
| Column | Datatype | Description |
|---|---|---|
DB_LINK |
VARCHAR2(128) |
Name of the database link |
OWNER_ID |
NUMBER |
Owner of the database link UID |
LOGGED_ON |
VARCHAR2(3) |
Whether the database link is currently logged on |
HETEROGENEOUS |
VARCHAR2(3) |
Whether the database link is heterogeneous |
PROTOCOL |
VARCHAR2(6) |
Communication protocol for the database link |
OPEN_CURSORS |
NUMBER |
Whether there are open cursors for the database link |
IN_TRANSACTION |
VARCHAR2(3) |
Whether the database link is currently in a transaction |
UPDATE_SENT |
VARCHAR2(3) |
Whether there has been an update on the database link |
COMMIT_POINT_STRENGTH |
NUMBER |
Commit point strength of the transactions on the database link |