V$DBLINK

V$DBLINK displays information about database links. You can view information about your own database links and database links 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.
owner_id	numeric	Owner ID of the current database link. If the owner of the database link is PUBLIC, the value of owner_id is 0.
logged_on	character varying(3)	Not supported. Set it to NULL.
heterogeneous	character varying(3)	Not supported. Set it to NULL.
protocol	character varying(6)	Not supported. Set it to NULL.
open_cursors	numeric	Not supported. Set it to NULL.
in_transaction	character varying(3)	Determines whether the current database link exists in a transaction. YES NO
update_sent	character varying(3)	Determines whether the current database link uses statements for updating data. YES NO
commit_point_strength	numeric	Not supported. Set it to NULL.
con_id	numeric	Not supported. Set it to NULL.