Oracle教程 2023-02-24

Oracle 视图 V$DBLINK 官方解释，作用，如何使用详细说明

本站中文解释

_INFO

V$DBLINK_INFO视图提供了所有与当前数据库相连接的数据库连接链路(dblink)的信息。可以跟踪每个dblink的当前状态，最近一次更改等信息。

使用方法:
要查看链接信息，请执行如下SQL查询：
“`SQL
SELECT * FROM V$DBLINK_INFO;
“`
查询可以返回链接的状态，最近一次更改的时间，本地连接地址，远程连接地址等信息。

官方英文解释

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
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

数据运维技术 » Oracle 视图 V$DBLINK 官方解释，作用，如何使用详细说明

分享到：

本站中文解释

官方英文解释

相关推荐