Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

V$ASM_VOLUME_STAT

In an Automatic Storage Management instance, V$ASM_VOLUME_STAT displays information about statistics for each Oracle ADVM volume. In a database instance, V$ASM_VOLUME_STAT displays no rows.

Column Datatype Description
GROUP_NUMBER NUMBER Cluster-wide number assigned to the disk group (composite primary key)
VOLUME_NAME VARCHAR2(30) Name of the volume
COMPOUND_INDEX NUMBER 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)
VOLUME_NUMBER NUMBER Number of the Volume within the disk group (composite primary key)
READS NUMBER Total number of read requests for this volume
WRITES NUMBER Total number of write requests for this volume
READ_ERRS NUMBER Total number of failed read I/O operations for this volume
WRITE_ERRS NUMBER Total number of failed write I/O operations for this volume
READ_TIME NUMBER Total I/O time (in hundredths of a second) for read requests for this volume
WRITE_TIME NUMBER Total I/O time (in hundredths of a second) for write requests for this volume
BYTES_READ NUMBER Total number of bytes read for this volume
BYTES_WRITTEN NUMBER Total number of bytes written for this volume