Column Name | Data Type | Description |
allocation_unit_size | NUMBER | Size of the allocation unit (in bytes) |
asm_instance_id | NUMBER | Primary key from the aps_v_asm_instance view |
block_size | NUMBER | ASM metadata block size (in bytes) |
coldusedmb | NUMBER | Number of used megabytes in the cold region |
compatibility | STRING | Minimum software version required for an ASM instance to mount this disk group |
database_compatibility | STRING | Minimum software version required for a database instance to use files in this disk group |
disk_group_id | NUMBER | System generated identifier for the Disk group |
disk_group_name | STRING | Name of the disk group |
freemb | NUMBER | Unused capacity of the disk group (in MiB) |
hotusedmb | NUMBER | Number of used megabytes in the hot region |
last_updated | DATE | Date and time last updated |
offline_disks | NUMBER | No.of disks in the disk group that are currently offline |
required_mirror_freemb | NUMBER | 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. |
sector_size | NUMBER | Physical block size (in bytes) |
state | STRING | State of the disk group relative to the instance with the following possible values: CONNECTED - Disk group is in use by the database instance BROKEN - Database instance lost connectivity to the ASM instance that mounted the disk group UNKNOWN - ASM instance has never attempted to mount the disk group DISMOUNTED - Disk group was cleanly dismounted by the ASM instance following a successful mount MOUNTED - Instance is successfully serving the disk group to its database clients QUIESCING - CRSCTL utility attempted to dismount a disk group that contains the Oracle Cluster Registry (OCR). The disk group cannot be dismounted until Cluster Ready Services (CRS) exits, because the disk group contains the OCR |
totalmb | NUMBER | Total capacity of the disk group (in MiB) |
type | STRING | Redundancy type for the disk group with the following possible values: EXTERNAL, NORMAL, HIGH |
usable_filemb | NUMBER | Amount of free space that can be safely utilized taking mirroring into account and yet be able to restore redundancy after a disk failure |
voting_files | STRING | Indicates whether the disk contains voting files (Y) or not (N) |