../E40402-16.epub /> ../E40402-16.mobi />

V$DBLINK

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