V$ASM_FILESYSTEM

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