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
`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`Foot 1	`NUMBER`	This column is not meaningful and its value is always `0`
`HOT_WRITES`Foot 1	`NUMBER`	This column is not meaningful and its value is always `0`
`HOT_BYTES_READ`Foot 1	`NUMBER`	This column is not meaningful and its value is always `0`
`HOT_BYTES_WRITTEN`Foot 1	`NUMBER`	This column is not meaningful and its value is always `0`
`COLD_READS`Foot 1	`NUMBER`	Number of reads from the disk
`COLD_WRITES`Foot 1	`NUMBER`	Number of writes to the disk
`COLD_BYTES_READ`Foot 1	`NUMBER`	Number of bytes read from the disk
`COLD_BYTES_WRITTEN`Foot 1	`NUMBER`	Number of bytes written to the 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`.

Footnote 1 Intelligent Data Placement is desupported starting with Oracle Database 21c. As a result, the HOT_READS, HOT_WRITES, HOT_BYTES_READ, and HOT_BYTES_WRITTEN columns are no longer meaningful and always return 0, and the COLD_READS, COLD_WRITES, COLD_BYTES_READ, and COLD_BYTES_WRITTEN columns return statistics for the entire disk.

Note: In an Oracle AI Database instance, this view returns 0 rows when queried from a PDB.

See Also: Oracle Automatic Storage Management Administrator’s Guide for additional information about using views to display Oracle ASM information