DBA_HIST_ASM_DISK_STAT

C.2.4 DBA_HIST_ASM_DISK_STAT_SUMMARY

The DBA_HIST_ASM_DISK_STAT_SUMMARY view displays historic summary information about Oracle ASM disk groups. It aggregates information from V$ASM_DISK_STAT.

Column	Datatype	NULL	Description
`SNAP_ID`	NUMBER	NOT NULL	Unique snapshot identifier.
`DBID`	NUMBER	NOT NULL	Database identifier for the snapshot.
`INSTANCE_NUMBER`	NUMBER	NOT NULL	Database instance number.
`GROUP_NUMBER`	NUMBER	NOT NULL	Cluster-wide number assigned to the disk group.
`READS`	NUMBER		Total number of I/O read requests for all disks in the disk group.
`WRITES`	NUMBER		Total number of I/O write requests for all disks in the disk group.
`READ_ERRS`	NUMBER		Total number of failed I/O read requests for all disks in the disk group.
`WRITE_ERRS`	NUMBER		Total number of failed I/O write requests for all disks in the disk group.
`READ_TIMEOUT`	NUMBER		Total number of failed I/O read requests that are timed out for all disks in the disk group.
`WRITE_TIMEOUT`	NUMBER		Total number of failed I/O write requests that are timed out for all disks in the disk group.
`READ_TIME`	NUMBER		Total I/O time (in seconds) for read requests for all disks in the disk group.
`WRITE_TIME`	NUMBER		Total I/O time (in seconds) for write requests for all disks in the disk group.
`BYTES_READ`	NUMBER		Total number of bytes read for all disks in the disk group.
`BYTES_WRITTEN`	NUMBER		Total number of bytes written for all disks in the disk group.
`CON_DBID`	NUMBER		The database identifier.
`CON_ID`	NUMBER		The identifier of the container identified by CON_DBID. Possible values are as follows: 0: This value is used for non-container database (CDB). 1: This value is used for the root container of the CDB.

Parent topic: Automatic Workload Repository Views