7.79 V$ASM_VOLUME_STAT
In an Oracle Automatic Storage Management (Oracle ASM) instance, V$ASM_VOLUME_STAT
displays information about statistics for each Oracle ADVM volume.
Column | Datatype | Description |
---|---|---|
|
|
Cluster-wide number assigned to the disk group (composite primary key) |
|
|
Name of the volume |
|
|
A 32-bit number consisting of a disk group number in the high-order 8 bits and a volume number in the low-order 24 bits (for efficient access to the view) |
|
|
Number of the Volume within the disk group (composite primary key) |
|
|
Total number of read requests for this volume |
|
|
Total number of write requests for this volume |
|
|
Total number of failed read I/O operations for this volume |
|
|
Total number of failed write I/O operations for this volume |
|
|
Total I/O time (in seconds) for read requests for this volume |
|
|
Total I/O time (in seconds) for write requests for this volume |
|
|
Total number of bytes read for this volume |
|
|
Total number of bytes written for this volume |
|
|
The ID of the container to which the data pertains. Possible values include:
For this view, the value is always |
See Also:
Oracle Automatic Storage Management Administrator's Guide for additional information about using views to display Oracle ASM information