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 |