V$ASM_DISK_IOSTAT displays information about disk I/O statistics for each ASM client. If this view is queried from the database instance, only the rows for that instance are shown.
| Column | Datatype | Description | 
|---|---|---|
INSTNAME | 
VARCHAR2(64) | 
Identifier for the DB/ADVM instance client | 
DBNAME | 
VARCHAR2(8) | 
Unique database name (DB_UNIQUE_NAME) | 
GROUP_NUMBER | 
NUMBER | 
Number of the disk group containing the disk | 
DISK_NUMBER | 
NUMBER | 
Number assigned to the disk within its disk group | 
FAILGROUP | 
VARCHAR2(30) | 
Name of the failure group to which the disk belongs | 
READS | 
NUMBER | 
Total number of I/O read requests for the disk | 
WRITES | 
NUMBER | 
Total number of I/O write requests for the disk | 
READ_ERRS | 
NUMBER | 
Total number of failed I/O read requests for the disk | 
WRITE_ERRS | 
NUMBER | 
Total number of failed I/O write 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). | 
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) | 
BYTES_READ | 
NUMBER | 
Total number of bytes read from the disk | 
BYTES_WRITTEN | 
NUMBER | 
Total number of bytes written from the 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 | 
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 | 
COLD_READS | 
NUMBER | 
Number of reads from the cold region on disk | 
COLD_WRITES | 
NUMBER | 
Number of writes to the cold region on 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 |