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

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.


See Also:

Oracle Automatic Storage Management Administrator's Guide for additional information about using views to display Oracle ASM information