Column Name | Data Type | Description |
asm_instance_id | NUMBER | Primary key from the aps_v_asm_instance view |
compatible_version | STRING | Compatibility setting of the database or ASM instance for the selected disk group connection |
db_instance_name | STRING | Identifier for the database instance client |
db_name | STRING | Unique database name of the database client instance |
last_updated | DATE | Date and time last updated |
status | 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 - Automatic Storage Management 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. |
version | STRING | Software version number of the database or ASM instance for the selected disk group connection |
Column Name | Data Type | Description |
asm_instance_id | NUMBER | Primary key from the aps_v_asm_instance view |
bytes_read | NUMBER | Total number of bytes read from the disk |
bytes_written | NUMBER | Total number of bytes written to the disk |
cold_bytes_read | NUMBER | Number of bytes read from the cold region on disk |
cold_bytes_written | NUMBER | Number of bytes written to the cold region on disk |
cold_reads | NUMBER | Number of reads from the cold region on disk |
cold_writes | NUMBER | Number of writes to the cold region on disk |
db_instance_name | STRING | Identifier for the database instance client |
disk_id | NUMBER | Primary key from the view |
hot_bytes_read | NUMBER | Number of bytes read from the hot region on disk |
hot_bytes_written | NUMBER | Number of bytes written to the hot region on disk |
hot_reads | NUMBER | Number of reads from the hot region on disk |
hot_writes | NUMBER | Number of writes to the hot region on disk |
log_date | DATE | Date and time the log record was created |
read_errs | NUMBER | Total number of failed I/O read requests for the disk |
read_time | NUMBER | Total I/O time (in seconds) for read requests for the disk if the TIMED_ STATISTICS initialization parameter is set to true (0 if set to false) |
reads | NUMBER | Total number of I/O read requests for the disk |
write_errs | NUMBER | Total number of failed I/O write requests for the disk |
write_time | NUMBER | Total I/O time (in seconds) for write requests for the disk if the TIMED_ STATISTICS initialization parameter is set to true (0 if set to false) |
writes | NUMBER | Total number of I/O write requests for the disk |
Column Name | Data Type | Description |
asm_instance_id | NUMBER | Primary key from the aps_v_asm_instance view |
disk_create_date | DATE | Date and time when the disk was added to the disk group |
disk_group_id | NUMBER | Primary key from the aps_v_asm_diskgroup view |
disk_id | NUMBER | System generated identifier for the Disk |
disk_mount_date | DATE | Date and time when the disk was mounted by the first instance |
disk_name | STRING | Name of the disk |
disk_path | STRING | Operating system path name portion of the name returned by discovery |
failgroup | STRING | Name of the failure group containing the disk |
failgroup_type | STRING | Type of the failure group with the following possible values: REGULAR QUORUM |
hash_value | NUMBER | A unique hash value for an ASM disk, computed using the ASM disk name and the ASM disk group name. |
header_status | STRING | Per-instance status of the disk as seen by discovery with the following possible values: UNKNOWN - ASM disk header has not been read CANDIDATE - Disk is not part of a disk group and may be added to a disk group with the ALTER DISKGROUP statement INCOMPATIBLE - Version number in the disk header is not compatible with the ASM software version PROVISIONED - Disk is not part of a disk group and may be added to a disk group with the ALTER DISKGROUP statement. The PROVISIONED header status is different from the CANDIDATE header status in that PROVISIONED implies that an additional platform-specific action has been taken by an administrator to make the disk available for ASM. MEMBER - Disk is a member of an existing disk group. No attempt should be made to add the disk to a different disk group. The ALTER DISKGROUP statement will reject such an addition unless overridden with the FORCE option. FORMER - Disk was once part of a disk group but has been dropped cleanly from the group. It may be added to a new disk group with the ALTER DISKGROUP statement. CONFLICT - ASM disk was not mounted due to a conflict FOREIGN - Disk contains data created by an Oracle product other than ASM. This includes datafiles, logfiles, and OCR disks. |
label | STRING | Disk label portion of the name returned by discovery |
last_updated | DATE | Date and time last updated |
library | STRING | Name of the library that discovered the disk |
mode_status | STRING | Global status about which kinds of I/O requests are allowed to the disk with the following possible values: ONLINE - Disk is online and operating normally. Reads and writes are attempted when the disk is mounted. Reads are attempted as part of disk discovery. OFFLINE - Disk is offline and access to data is not permitted. Reads and writes are not attempted. An offline disk remains logically part of its disk group. |
mount_status | STRING | Per-instance status of the disk relative to group mounts with the following possible values: MISSING - Automatic Storage Management metadata indicates that the disk is known to be part of the Automatic Storage Management (ASM) disk group but no disk in the storage system was found with the indicated name CLOSED - Disk is present in the storage system but is not being accessed by ASM OPENED - Disk is present in the storage system and is being accessed by ASM. This is the normal state for disks in a database instance which are part of a Disk Group being actively used by the instance. CACHED - Disk is present in the storage system and is part of a disk group being accessed by the ASM instance. This is the normal state for disks in an ASM instance which are part of a mounted disk group. IGNORED - Disk is present in the system but is ignored by ASM because of one of the following: -- The disk is detected by the system library but is ignored because an ASM library discovered the same disk -- ASM has determined that the membership claimed by the disk header is no longer valid CLOSING - ASM is in the process of closing this disk |
preferred_read | STRING | Status of the preferred read failure group with the following possible values: U - Disk group has no preferred read failure group Y - Disk is a preferred read disk N - Disk is not a preferred read disk For a disk group with one or more preferred read failure groups, if the disk is in one of the preferred read failure groups, the value of this column is Y; otherwise it is N. |
product | STRING | Name of the manufacturer and the name of the product. All disks with the same product id will have the same performance and reliability characteristics |
redundancy | STRING | Hardware redundancy of the disk with the following possible values: UNKNOWN UNPROT MIRROR PARITY |
repair_timer | NUMBER | Seconds remaining until the disk is automatically dropped (0 if not failed) |
sector_size | NUMBER | Physical block size (in bytes) |
state | STRING | Global state of the disk with respect to the disk group with the following possible values: UNKNOWN - ASM disk state is not known (typically the disk is not mounted) NORMAL - Disk is online and operating normally ADDING - Disk is being added to a disk group, and is pending validation by all instances that have the disk group mounted DROPPING - Disk has been manually taken offline and space allocation or data access for the disk halts. Rebalancing will commence to relocate data off the disks to other disks in the disk group. Upon completion of the rebalance, the disk is expelled from the group. HUNG - Disk drop operation cannot continue because there is insufficient space to relocate the data from the disk being dropped FORCING - Disk is being removed from the disk group without attempting to offload its data. The data will be recovered from redundant copies, where possible. DROPPED - Disk has been fully expelled from the disk group |
udib | STRING | Unique Device ID portion of the name returned by discovery |
voting_file | STRING | Indicates whether the disk contains a voting file (Y) or not (N) |
Column Name | Data Type | Description |
asm_instance_id | NUMBER | Primary key from the aps_v_asm_san_details view |
coldusedmb | NUMBER | Number of used megabytes in the cold region |
disk_group_id | NUMBER | Primary key from the aps_v_asm_diskgroup view |
disk_id | NUMBER | Primary key from the aps_v_asm_disk view |
freemb | NUMBER | Unused capacity of the disk (in MiB) |
hotusedmb | NUMBER | Number of used megabytes in the hot region |
log_date | DATE | Date and time the log record was created |
osmb | NUMBER | Size of the disk (in MiB) as reported by the host operating system |
totalmb | NUMBER | Total capacity of the disk (in MiB) |
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) |
Column Name | Data Type | Description |
asm_instance_id | NUMBER | Primary key from the aps_v_asm_san_details view |
db_instance_name | STRING | Identifier for the database instance client |
disk_group_id | NUMBER | Primary key from the aps_v_asm_diskgroup view |
last_updated | DATE | Date and time last updated |
Column Name | Data Type | Description |
asm_instance_id | NUMBER | Primary key from the aps_v_asm_san_details view |
bytes_read | NUMBER | Total number of bytes read from the disk |
bytes_written | NUMBER | Total number of bytes written to the disk |
cold_bytes_read | NUMBER | Number of bytes read from the cold region on disk |
cold_bytes_written | NUMBER | Number of bytes written to the cold region on disk |
cold_reads | NUMBER | Number of reads from the cold region on disk |
cold_writes | NUMBER | Number of writes to the cold region on disk |
disk_id | NUMBER | Primary key from the aps_v_asm_disk view |
hot_bytes_read | NUMBER | Number of bytes read from the hot region on disk |
hot_bytes_written | NUMBER | Number of bytes written to the hot region on disk |
hot_reads | NUMBER | Number of reads from the hot region on disk |
hot_writes | NUMBER | Number of writes to the hot region on disk |
log_date | DATE | Date and time the log record was created |
read_errs | NUMBER | Total number of failed I/O read requests for the disk |
read_time | NUMBER | Total I/O time (in seconds) for read requests for the disk if the TIMED_ STATISTICS initialization parameter is set to true (0 if set to false) |
reads | NUMBER | Total number of I/O read requests for the disk |
write_errs | NUMBER | Total number of failed I/O write requests for the disk |
write_time | NUMBER | Total I/O time (in seconds) for write requests for the disk if the TIMED_ STATISTICS initialization parameter is set to true (0 if set to false) |
writes | NUMBER | Total number of I/O write requests for the disk |
Column Name | Data Type | Description |
asm_instance_id | NUMBER | Primary key from the aps_v_asm_san_details view |
block_size | NUMBER | Block size of the file (in bytes) |
blocks | NUMBER | Number of blocks in the file |
bytes | NUMBER | Number of bytes in the file |
db_name | STRING | Unique database name of the database client instance |
disk_group_id | NUMBER | Primary key from the aps_v_asm_diskgroup view |
file_creation_date | DATE | Date and time file was created |
file_incarnation | NUMBER | Incarnation number for the file (composite primary key) |
file_modified_date | DATE | Date and time file was modified |
file_name | STRING | Alias name on the combination of file_number and file_incarnation |
file_number | NUMBER | Number of the file within the disk group (composite primary key) |
file_type_tag | STRING | Type specific information about the file |
last_updated | DATE | Date and time last updated |
redundancy | STRING | Redundancy of the file with the following possible values: UNPROT MIRROR HIGH |
redundancy_lowered | STRING | Indicates whether a file has lower redundancy than what was expected (Y) or not (N). Redundancy is said to have been lowered for a file when one or more data extents in that file are not mirrored at the level specified by the administrator. In case of unprotected files, data extents could be missing altogether. Another possible value for this column is (U), which means that it is unknown |
space | NUMBER | Number of bytes allocated to the file |
striped | STRING | Indicates how the file is striped with the following possible values: FINE COARSE |
type | STRING | Type of the file. Possible values are as follows: CONTROLFILE DATAFILE ONLINELOG ARCHIVELOG TEMPFILE BACKUPSET XTRANSPORT PARAMETERFILE DATAGUARDCONFIG FLASHBACK CHANGETRACKING DUMPSET AUTOBACKUP |
Column Name | Data Type | Description |
asm_instance_id | NUMBER | System generated identifier for the ASM instance |
asm_instance_name | STRING | Name of the ASM instance |
host_id | NUMBER | Server on which this ASM runs |
Column Name | Data Type | Description |
host_id | NUMBER | Foreign key to host details |
disk_id | NUMBER | Foreign key to disk details |
host_disk_id | NUMBER | Foreign key to host disk details |
logical_unit_id | NUMBER | Foreign key to logical unit details |
logical_unit_name | STRING | Logical unit name |
storage_array_id | NUMBER | Foreign key to storage array details |
array_name | STRING | Array name |