7.68 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 |
---|---|---|
|
|
Number of the Disk Group in which this File Group exists (composite primary key) |
|
|
Number associated to the File Group within its Disk Group (composite primary key) |
|
|
Incarnation number for the File Group (composite primary key) |
|
|
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 of the File Group |
|
|
Type of client that the File Group is associated to:
|
|
|
Name of the client (database, PDB, CDB, cluster, or volume) that the File Group is associated to |
|
|
If the
CLIENT_TYPE is DATABASE :
If the |
|
|
Number of the quota group associated with this File Group (foreign key to the |
|
|
Incarnation number for the Quota Group |
|
|
Used quota of the quota group in GB |
|
|
User number |
|
|
Incarnation number of the user |
|
|
User group number |
|
|
Incarnation number of the user group |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also: