Oracle教程

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

本站中文解释

V$DNFS_CHANNELS视图主要显示Distributed Network File System（DNFS）接口的使用状况，该接口是用于与外部文件系统进行交换的Oracle DNFS的口令。

V$DNFS_CHANNELS视图中存储的信息包括：通道ID，请求类型，总流量，当前的活动请求的总数，错误次数，当前的活跃请求数，超时的次数，最大排队请求数，当前排队请求数，最大IO数，最后一次澈底时间，以及总空闲时间等。管理员可以根据该视图中的信息来监控DNFS通道的状态，了解DNFS远程调用的性能情况。

要使用V$DNFS_CHANNELS视图，首先需要连接到Oracle数据库，然后输入以下SQL语句：

SELECT * FROM V$DNFS_CHANNELS;

这将会返回所有DNFS通道的详细信息。

官方英文解释

V$DNFS_CHANNELS displays information about the Oracle process connections (channels) open to NFS servers.

Column Datatype Description

PNUM

NUMBER

Oracle process number

SVRNAME

VARCHAR2(255)

NFS server name

PATH

VARCHAR2(255)

Network path to the NFS server specified by IP address or by name

LOCAL

VARCHAR2(255)

Local path on the database host specified by IP address or by name

CH_ID

NUMBER

Direct NFS channel identifier

SVR_ID

NUMBER

Direct NFS server identifier

SENDS

NUMBER

Send operations over the channel since the last select

RECVS

NUMBER

Receive operations over the channel since the last select

PINGS

NUMBER

Ping operations over the channel since the last select

SPRECO

NUMBER

Reconnects for the channel on the same port since the last select, given that the reconnect occurred during the first series of reconnect attempts. If the first series of reconnect attempts fails and the reconnect process on that channel times out for 5 minutes, the next reconnect on that channel will not increment either the SPRECO or DPRECO columns, regardless of the port connected to.

DPRECO

NUMBER

Reconnects for the channel on a different port since the last select, given that the reconnect occurred during the first series of reconnect attempts. If the first series of reconnect attempts fails and the reconnect process on that channel times out for 5 minutes, the next reconnect on that channel will not increment either the SPRECO or DPRECO columns, regardless of the port connected to.

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

RDMA

NUMBER

Indicates whether RDMA is enabled for the channel or not. Possible values:

  • 0: RDMA is not enabled for the channel

  • 1: RDMA is enabled for the channel

RDMA_CREDITS

NUMBER

The number of RDMA credits supported by the server

CLIENTPORT

NUMBER

The client port to which the channel is bounded

ACTIVE_SPEED

NUMBER

The active speed of the HCA card present (in Gb/second)

PEAK_FMR

NUMBER

The size of fast memory registration (FMR) memory registered by the channel (in bytes)

CURRENT_FMR

NUMBER

The current FMR memory registered (in bytes)

FMRREG_COUNT

NUMBER

The number of FMR memory registration calls for the channel

Note:

RDMA functionality is enabled only for the Exadata environment


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

相关推荐