7.58 V$ASM_DISK
V$ASM_DISK
displays one row for every disk discovered by the Oracle Automatic Storage Management (Oracle ASM) instance, including disks that are not part of any disk group.
Column | Datatype | Description |
---|---|---|
|
|
Number of the disk group containing the disk (foreign key to the |
|
|
Number assigned to the disk within its disk group |
|
|
A 32-bit number consisting of a disk group number in the high-order 8 bits and a disk number in the low-order 24 bits (for efficient access to the view) |
|
|
Incarnation number for the disk |
|
|
Per-instance status of the disk relative to group mounts:
|
|
|
Per-instance status of the disk as seen by discovery:
|
|
|
Global status about which kinds of I/O requests are allowed to the disk:
|
|
|
Global state of the disk with respect to the disk group:
|
|
|
Hardware redundancy of the disk:
Note: This column is valid only if an ASMLIB is present that supports returning hardware redundancy information. This column is not related to the redundancy of the disk group of which the disk is a member. |
|
|
Name of the library that discovered the disk |
|
|
Size of the disk (in megabytes) as reported by the host operating system |
|
|
Total capacity of the disk (in megabytes) |
|
|
Unused capacity of the disk (in megabytes) |
|
|
Number of used megabytes in the hot region |
|
|
Number of used megabytes in the cold region |
|
|
Name of the disk |
|
|
Name of the failure group containing the disk |
|
|
Disk label portion of the name returned by discovery |
|
|
Operating system path name portion of the name returned by discovery |
|
|
Unique Device ID portion of the name returned by discovery |
|
|
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. |
|
|
Date and time when the disk was added to the disk group |
|
|
Date and time when the disk was mounted by the first instance |
|
|
Seconds remaining until the disk is automatically dropped ( |
|
|
Total number of I/O read requests for the disk |
|
|
Total number of I/O write requests for the disk |
|
|
Total number of failed I/O read requests for the disk |
|
|
Total number of failed I/O write requests for the disk |
|
|
Number of read I/Os that are timed out |
|
|
Number of write I/Os that are timed out |
|
|
Total I/O time (in seconds) for read requests for the disk if the |
|
|
Total I/O time (in seconds) for write requests for the disk if the |
|
|
Total number of bytes read from the disk |
|
|
Total number of bytes written to the disk |
|
|
Status of the preferred read failure group:
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 |
|
|
A unique hash value for an Oracle ASM disk, computed using the Oracle ASM disk name (as specified by |
|
|
Number of reads from the hot region on disk |
|
|
Number of writes to the hot region on disk |
|
|
Number of bytes read from the hot region on disk |
|
|
Number of bytes written to the hot region on disk |
|
|
Number of reads from the cold region on disk |
|
|
Number of writes to the cold region on disk |
|
|
Number of bytes read from the cold region on disk |
|
|
Number of bytes written to the cold region on disk |
|
|
Indicates whether the disk contains a voting file ( |
|
|
Physical block size (in bytes) |
|
|
Shows the logical sector size value of the disk in bytes. This is the smallest possible I/O that can be done by the disk. If the value of the |
|
|
Type of the failure group:
|
|
|
The ID of the container to which the data pertains. Possible values include:
For this view, the value is always |
|
|
Indicates whether the disk supports Storage Thin Provisioning ( |
|
|
Indicates whether the disk supports the Data Integrity feature ( |
|
|
The name of the site to which the specific disk belongs |
|
|
The GUID for the site to which the specific disk belongs |
|
|
This is the suggested name for the failure group to which the disk belongs, as returned by discovery |
|
|
This is the suggested name for the site to which the disk belongs, as returned by discovery |
|
|
This column is populated only for disks in Oracle ASM extended disk groups. The site status is computed after every Partnership and Status Table (PST) refresh or when the PST is read from disks into memory. The possible states include:
|
Note:
The GROUP_NUMBER
and DISK_NUMBER
columns will only be valid if the disk is part of a disk group which is currently mounted by the instance. Otherwise, GROUP_NUMBER
will be 0
, and DISK_NUMBER
will be a unique value with respect to the other disks that also have a group number of 0
.
Note:
This view performs disk discovery every time it is queried. Because performing disk discovery is very resource intensive, Oracle recommends against using this view for monitoring scripts. Instead, use the less expensive view V$ASM_DISK_STAT.
See Also:
Oracle Automatic Storage Management Administrator's Guide for additional information about using views to display Oracle ASM information