V$ASM_DISK_IOSTAT

7.55 V$ASM_DISK_IOSTAT

V$ASM_DISK_IOSTAT displays information about disk I/O statistics for each Oracle Automatic Storage Management (Oracle 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`)
`CLUSTERNAME`	`VARCHAR2(31)`	Name of the cluster
`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
`SITE_NAME`	`VARCHAR2(30)`	This is the name of the site to which the disk belongs This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).
`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_TIMEOUT`	`NUMBER`	Number of read I/Os that are timed out
`WRITE_TIMEOUT`	`NUMBER`	Number of write I/Os that are timed out
`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
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data For this view, the value is always `0`.