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.

See Also:

  • “V$OFS_STATS”

  • Oracle Database PL/SQL
    Packages and Types Reference
    for more information about the DBMS_FS.MOUNT_ORACLE_FS procedure