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/AVD 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 hundreths of a second) 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 hundreths of a second) 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 |