Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)
Part Number B14237-02
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Index
Index		 Go to Master Index
Master Index		 Go to Feedback page
Feedback
Go to previous page
Previous		 Go to next page
Next
View PDF

V$DBLINK

This view 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

Go to previous page
Previous		 Go to next page
Next
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Index
Index		 Go to Master Index
Master Index		 Go to Feedback page
Feedback