Oracle教程 2023-02-24

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

本站中文解释

Oracle视图 V$ASM_FILESYSTEM 旨在列出当前己挂载在ASM实例上的所有ASM文件系统。

它报告有关每个挂载点文件系统的状态、属性和注释信息，如文件系统状态、名称、类型、文件系统中空间的使用情况等。

用户可以使用此视图来查询当前挂载在ASM实例上的ASM文件系统的详细信息，如状态、大小等信息。

例如，可以使用以下查询语句查看挂载的ASM文件系统的状态和大小：

“`sql
SELECT mount_status,
space_used,
space_total
FROM v$asm_filesystem;
“`

官方英文解释

V$ASM_FILESYSTEM displays information for every mounted Oracle ACFS.

Column	Datatype	Description
`FS_NAME`	`VARCHAR2(1024)`	Mount point (primary key)
`AVAILABLE_TIME`	`DATE`	Mount time or the time that the file system became available again; NULL if the file system is not available
`BLOCK_SIZE`	`NUMBER`	File system block size (in kilobytes)
`STATE`	`VARCHAR2(13)`	File system status:: `NOT AVAILABLE` `AVAILABLE` `OFFLINE` – Either the Oracle ASM instance is down, the disk group has been forced dismounted, or less commonly, a metadata I/O failure occurred or serious metadata corruption was detected. In the case of a metadata I/O failure, the file system is also marked as corrupt. An offline file system can only be unmounted; other attempts at access result in errors.
`CORRUPT`	`VARCHAR2(5)`	Indicates whether the file system needs the fixer (`fsck`, `acfschkdsk`) to be run (`TRUE`) or not (`FALSE`)
`NUM_VOL`	`NUMBER`	Number of volumes in the file system
`TOTAL_SIZE`	`NUMBER`	Total capacity of the file system (in megabytes)
`TOTAL_FREE`	`NUMBER`	Total free space in the file system (in megabytes)
`TOTAL_SNAP_SPACE_USAGE`	`NUMBER`	Total space used by snapshots (in megabytes)
`REPLSTATE`	`VARCHAR2(7)`	Replication status: `NO REPL` – Replication is not initialized `PRIMARY` – File system is initialized for replication as a primary `STANDBY` – File system is initialized for replication as a standby
`RESIZE_STATE`	`VARCHAR2(5)`	Possible resize states: `NONE` – AutoResize not configured `AUTO` – Equivalent to AutoResizeEnabled flag `ERROR` – Equivalent to AutoResizeError flag
`COMPRESS_STATE`	`VARCHAR2(7)`	Compression status of the file system. Possible values: `DISABLED` – Compression is not active `ENABLED` – Compression is active `PARTIAL` – Compression is disabled, but the file system may contain compressed files
`FROZEN_STATE`	`VARCHAR2(5)`	Indicates whether the filesystem is frozen (`TRUE`) or not (`FALSE`)
`ACFS_COMPATIBILITY`	`VARCHAR2(60)`	Oracle Release streams where Oracle ACFS has shipped
`METADATA_BLOCK_SIZE`	`NUMBER`	Metadata block size of the file system. Possible values: 512 4096
`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 For this view, the value is always `0`.

本站中文解释

官方英文解释

相关推荐