V$ASM_FILEGROUP

7.61 V$ASM_FILEGROUP

V$ASM_FILEGROUP describes the properties of the Oracle Automatic Storage Management (Oracle ASM) File Groups.

In both Oracle ASM and Oracle Database instances, V$ASM_FILEGROUP displays one row for every File Group present in every Disk Group mounted by the Oracle ASM instance. File Groups are only displayed for Disk Groups where COMPATIBLE.ASM is set to 12.2 or higher.

Note:

There will not be an entry for the default File Group.

Column	Datatype	Description
`GROUP_NUMBER`	`NUMBER`	Number of the Disk Group in which this File Group exists (composite primary key)
`FILEGROUP_NUMBER`	`NUMBER`	Number associated to the File Group within its Disk Group (composite primary key)
`INCARNATION`	`NUMBER`	Incarnation number for the File 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 Group number in the low-order 24 bits (for efficient access to the view)
`NAME`	`VARCHAR2(128)`	Name of the File Group
`CLIENT_TYPE`	`NUMBER`	Type of client that the File Group is associated to: `DATABASE` `CLUSTER` `VOLUME`
`CLIENT_NAME`	`VARCHAR2(128)`	Name of the client (database, PDB, CDB, cluster, or volume) that the File Group is associated to
`GUID`	`VARCHAR2(32)`	If the `CLIENT_TYPE` is `DATABASE`: In a CDB environment, it is the GUID of the PDB or CDB associated with the file group, the same value as the GUID in `V$CONTAINERS`. In a non-CDB environment it is the database identifier (DBID) of the database associated with that file group. If the `CLIENT_TYPE` is `VOLUME` or `CLUSTER`, the `GUID` column is empty.
`QUOTAGROUP_NUMBER`	`NUMBER`	Number of the quota group associated with this File Group (foreign key to the `V$ASM_QUOTAGROUP` view)
`QUOTAGROUP_INCARNATION`	`NUMBER`	Incarnation number for the Quota Group
`USED_QUOTA_MB`	`NUMBER`	Used quota of the quota group in GB
`USER_NUMBER`	`NUMBER`	User number
`USER_INCARNATION`	`NUMBER`	Incarnation number of the user
`USERGROUP_NUMBER`	`NUMBER`	User group number
`USERGROUP_INCARNATION`	`NUMBER`	Incarnation number of the user group
`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:

The following columns are available starting with Oracle Database 12c Release 2 (12.2.0.1):

USED_QUOTA_MB
USER_NUMBER
USER_INCARNATION
USERGROUP_NUMBER
USERGROUP_INCARNATION

Note:

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