7.64 V$ASM_DISKGROUP
V$ASM_DISKGROUP
displays one row for every Oracle Automatic Storage Management (Oracle ASM) disk group discovered by the Oracle ASM instance on the node.
Column | Datatype | Description |
---|---|---|
|
|
Cluster-wide number assigned to the disk group (primary key) |
|
|
Name of the disk group |
|
|
Physical block size (in bytes) |
|
|
This column represents the logical sector size value of the disk group in bytes. This is the smallest possible I/O that can be done in this disk group. Any I/O smaller than the logical sector size will cause an assert in the code. If the value of the |
|
|
Oracle ASM metadata block size (in bytes) |
|
|
Size of the allocation unit (in bytes) |
|
|
State of the disk group relative to the instance:
|
|
|
Redundancy type for the disk group:
|
|
|
Total capacity of the disk group, excluding that of quorum disks (in megabytes) |
|
|
Unused capacity of the disk group (in megabytes) |
|
|
Number of used megabytes in the hot region |
|
|
Number of used megabytes in the cold region |
|
|
Amount of space that is required to be available in a given disk group in order to restore redundancy after one or more disk failures. The amount of space displayed in this column takes mirroring effects into account. |
|
|
Amount of free space that can be safely utilized taking mirroring into account and yet be able to restore redundancy after a disk failure |
|
|
Number of disks in the disk group that are currently offline |
|
|
Minimum software version required for an Oracle ASM instance to mount this disk group |
|
|
Minimum software version required for a database instance to use files in this disk group |
|
|
Indicates whether the disk contains voting files ( |
|
|
The ID of the container to which the data pertains. Possible values include:
For this view, the value is always |
Note:
The GROUP_NUMBER
, TOTAL_MB
, and FREE_MB
columns are only meaningful if the disk group is mounted by the instance. Otherwise, their values will be 0
.
See Also:
Oracle Automatic Storage Management Administrator's Guide for additional information about using views to display Oracle ASM information