1. Database Reference
  2. Dynamic Performance Views
  3. Dynamic Performance (V$) Views: V$ACCESS to V$HVMASTER_INFO
  4. V$ASM_FILEGROUP_FILE

7.62 V$ASM_FILEGROUP_FILE

V$ASM_FILEGROUP_FILE lists all the Oracle Automatic Storage Management (Oracle ASM) files associated with each File Group.

In both Oracle ASM and Oracle Database instances, V$ASM_FILEGROUP_FILE will display one row for every file associated with a File Group contained in every Disk Group mounted by the instance.

Column Datatype Description

GROUP_NUMBER

NUMBER

Number of the Disk Group in which this File Group exists

FILEGROUP_NUMBER

NUMBER

Number associated to the File Group within its Disk Group

FILEGROUP_INCARN

NUMBER

Incarnation number for the File Group

FILE_NUMBER

NUMBER

Number associated to the ASM File (same file number as in V$ASM_FILE)

INCARNATION

NUMBER

Incarnation number for the ASM File

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)

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

Note:

This view is available starting with Oracle Database 12c Release 2 (12.2.0.1).

See Also: