7.71 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_STATEFoot 1

VARCHAR2(5)

Possible resize states:
  • NONE - AutoResize not configured

  • AUTO - Equivalent to AutoResizeEnabled flag

  • ERROR - Equivalent to AutoResizeError flag

COMPRESS_STATEFoot 1

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_STATEFoot 1

VARCHAR2(5)

Indicates whether the filesystem is frozen (TRUE) or not (FALSE)

ACFS_COMPATIBILITYFoot 1

VARCHAR2(60)

Oracle Release streams where ACFS has shipped

METADATA_BLOCK_SIZEFoot 1

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.

Footnote 1 This column is available starting with Oracle Database release 19c, version 19.1.

See Also:

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