Oracle教程 2023-02-28

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

Oracle的视图V$DNFS_SERVERS用来创建和管理存储在NFS服务器上的数据库文件。它提供一种简单的方法来共享文件并查看存储在NFS服务器上的文件列表。有关NFS服务器的完整信息存储在V$DNFS_SERVERS视图中，可以通过SELECT语句从中获取。

V$DNFS_SERVERS视图返回的信息包括NFS服务器的名称、类型、路径和状态等。使用该视图可以查看NFS服务器上文件的详细信息，并以程序方式访问它们。V$DNFS_SERVERS视图还可以用于更新、添加和删除NFS服务器上的文件，并定期检查它们的状态。

V$DNFS_SERVERS displays information about the Direct NFS servers accessed by Direct NFS.

Column	Datatype	Description
`ID`	`NUMBER`	Direct NFS server identifier
`SVRNAME`	`VARCHAR2(255)`	NFS server name
`DIRNAME`	`VARCHAR2(1024)`	Mounted directory
`MNTPORT`	`NUMBER`	NFS mount port
`NFSPORT`	`NUMBER`	NFS port
`NFSVERSION`	`VARCHAR2(8)`	NFS version
`WTMAX`	`NUMBER`	WTMAX exported by the NFS server
`RTMAX`	`NUMBER`	RTMAX exported by the NFS server
`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
`RDMAENABLE`	`VARCHAR2(16)`	Indicates whether the server is RDMA enabled. Possible values: `YES`: The server is RDMA enabled. `NO`: The server is not RDMA enabled.
`RDMAPORT`	`NUMBER`	The port number for RDMA communications on the server. The value is always 20049.
`SECURITY`	`VARCHAR2(32)`	NFS RPC authentication method used for the given NFS export

Note:

RDMA functionality is enabled only for the Exadata environment

分享到：