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.


See Also:

Oracle Automatic Storage Management Administrator's Guide for additional information about using views to display Oracle ASM information