V$ASM_FILESYSTEM

8.66 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`.