Oracle教程 2023-04-02

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

oracle 视图V$CLUSTER_INTERCONNECTS用于提供系统间互联信息，它被存储在Oracle 服务中用于监视系统共数据交换。该视图简单地显示了每个系统间互联的状态。

使用方法：

1. 查询某个会话所代表的连接：
SELECT *
FROM v$cluster_interconnects
WHERE sid = ;

2. 查询某台服务器的系统连接：
SELECT *
FROM v$cluster_interconnects
WHERE node_id = ;

V$CLUSTER_INTERCONNECTS displays one or more interconnects that are being used for cluster communication.

Column	Datatype	Description
`NAME`	`VARCHAR2(15)`	Name of the interconnect (such as eth0)
`IP_ADDRESS`	`VARCHAR2(64)`	IP address of the interconnect
`IS_PUBLIC`	`VARCHAR2(3)`	If the value is `YES`, the interface is known to the public. If the value is `NO`, the interface is known to be private. Note that if the `CLUSTER_INTERCONNETS` initialization parameter is also specified, then it is expected that the interconnect is private. Oracle expects cluster traffic to be run on private interconnects only. f the value is empty, it is unknown whether the interface is public or private. Oracle recommends that you set the interface for Oracle Real Application Clusters (Oracle RAC) communication in the Oracle Cluster Registry (OCR).
`SOURCE`	`VARCHAR2(31)`	Indicates where this interface was picked up from: Oracle Cluster Registry – Interface was configured in the OCR and Oracle Database found the interface in the OCR Operating-system dependent software – Oracle Database automatically detects this `CLUSTER_INTERCONNECTS` parameter – This initialization parameter was set
`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

分享到：