V$ASM_FILE

In an Automatic Storage Management instance, V$ASM_FILE displays one row for every Automatic Storage Management file in every disk group mounted by the Automatic Storage Management instance. In a database instance, V$ASM_FILE displays no rows.

Column

Datatype

Description

GROUP_NUMBER

NUMBER

Number of the disk group containing the file (composite primary key)

FILE_NUMBER

NUMBER

Number of the file within the disk group (composite primary key)

COMPOUND_INDEX

NUMBER

A 32-bit number consisting of a disk group number in the high-order 8 bits and a file number in the low-order 24 bits (for efficient access to the view)

INCARNATION

NUMBER

Incarnation number for the file (composite primary key)

BLOCK_SIZE

NUMBER

Block size of the file (in bytes)

BLOCKS

NUMBER

Number of blocks in the file

BYTES

NUMBER

Number of bytes in the file

SPACE

NUMBER

Number of bytes allocated to the file

TYPE

VARCHAR2(64)

Type of the file. Possible values are as follows:

CONTROLFILE

DATAFILE

ONLINELOG

ARCHIVELOG

TEMPFILE

BACKUPSET

XTRANSPORT

PARAMETERFILE

DATAGUARDCONFIG

FLASHBACK

CHANGETRACKING

DUMPSET

AUTOBACKUP

REDUNDANCY

VARCHAR2(6)

Redundancy of the file:

UNPROT

MIRROR

HIGH

STRIPED

VARCHAR2(6)

Indicates how the file is striped:

FINE

COARSE

CREATION_DATE

DATE

Date on which the file was created

MODIFICATION_DATE

DATE

Date of the last open/close for writing, rounded back to the nearest hour

REDUNDANCY_LOWERED

VARCHAR2(1)

Indicates whether a file has lower redundancy than what was expected (Y) or not (N). Redundancy is said to have been lowered for a file when one or more data extents in that file are not mirrored at the level specified by the administrator. In case of unprotected files, data extents could be missing altogether. Another possible value for this column is (U), which means that it is unknown.