Oracle教程 2023-02-24

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

Oracle视图V$OFSMOUNT 是Oracle 网络服务或 Oracle 嵌入式网络访问服务的一部分，该视图显示系统上测量的文件系统挂载操作。它可以多次显示Oracle Data Cartridges的诸如KGFF和IPFS Tools的文件系统的挂载信息。

要使用V$OFSMOUNT视图，您可以使用SELECT语句以查看文件系统的挂载信息：

SELECT file_system, Mount_Location, Status, Type
FROM v$ofsmount ORDER BY file_system;

V$OFSMOUNT provides information about the file systems that are mounted by Oracle File System.

Column	Datatype	Description
`OFS_MNTPATH`	`VARCHAR2(1024)`	Mount path where the file system is mounted
`OFS_FSPATH`	`VARCHAR2(1024)`	File system path
`OFS_MNTOPTS`	`VARCHAR2(1024)`	Mount options used to mount the file system
`OFS_MNTFLAGS`	`VARCHAR2(7)`	Flags to specify if the file system is mounted. A value of 1 indicates that the file system is mounted.
`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
`OFS_NODENM`	`VARCHAR2(255)`	Node name
`OFS_FSID`	`NUMBER`	Unique ID that identifies the mounted file system
`OFS_FSTYPE`	`VARCHAR2(255)`	Oracle file system type. This is the value that is passed to the `dbms_fs.mount_oracle_fs()` procedure. Some of the expected values are `dbfs` and `ofs`.

Note:

This database view is supported only on the Linux operating system.