V$DBLINK

V$DBLINK displays information about DATABASE LINK objects. You can view information about your own DATABASE LINK objects and DATABASE LINK objects at the PUBLIC level. By default, only administrators can view this view.

The data in this view is obtained from GS_DB_LINKS. This view records only the information about the links that have been used or are being used in the current session. For details about database links, see DATABASE LINK.

**Table 1** V$DBLINK columns
Name	Type	Description
db_link	character varying(128)	Name of the current DATABASE LINK object.
owner_id	numeric	Owner ID of the current DATABASE LINK object. If the owner of the DATABASE LINK object is PUBLIC, the value of owner_id is 0.
logged_on	character varying(3)	Not supported. Its value is NULL.
heterogeneous	character varying(3)	Not supported. Its value is NULL.
protocol	character varying(6)	Not supported. Its value is NULL.
open_cursors	numeric	Not supported. Its value is NULL.
in_transaction	character varying(3)	Specifies whether the current DATABASE LINK object exists in a transaction. YES NO
update_sent	character varying(3)	Specifies whether the current DATABASE LINK object uses statements for updating data. YES NO
commit_point_strength	numeric	Not supported. Its value is NULL.
con_id	numeric	Not supported. Its value is NULL.