C.2.10 DBA_HIST_CELL_DISK_SUMMARY

The DBA_HIST_CELL_DISK_SUMMARY view displays historic information about the performance of disks on cells. For each AWR snapshot, a summary of the per-minute metrics is visible in this view. Each metric stores the sum and the sum of squares, similar to DBA_HIST_SYSMETRIC_SUMMARY. This view is a summary of V$CELL_DISK_HISTORY.

Column Datatype NULL Description

SNAP_ID

NUMBER

NOT NULL

Unique snapshot identifier.

DBID

NUMBER

NOT NULL

Database identifier for the snapshot.

CELL_HASH

NUMBER

NOT NULL

Hash number to uniquely identify the cell.

DISK_ID

NUMBER

NOT NULL

Unique identifier of the disk.

NUM_SAMPLES

NUMBER

Number of one-minute samples the summary is based on.

DISK_UTILIZATION_SUM

NUMBER

Sum of the per-minute disk utilization metrics. This is based on OS statistics.

READS_SUM

NUMBER

Sum of the per-minute read requests metrics per second. This is based on OS statistics.

READ_MB_SUM

NUMBER

Sum of the per-minute read metrics, in megabytes per second. This is based on OS statistics.

WRITES_SUM

NUMBER

Sum of the per-minute write requests metrics, per second. This is based on OS statistics.

WRITE_MB_SUM

NUMBER

Sum of the per-minute write metrics, in megabytes per second. This is based on OS statistics.

IO_REQUESTS_SUM

NUMBER

Sum of the per-minute IOPs. This is based on OS statistics.

IO_MB_SUM

NUMBER

Sum of the per-minute I/O metrics, in megabytes per second. This is based on OS statistics.

SERVICE_TIME_SUM

NUMBER

Sum of the per-minute service time metrics. This is based on OS statistics.

WAIT_TIME_SUM

NUMBER

Sum of the per-minute wait time metrics. This is based on OS statistics.

SMALL_READS_SUM

NUMBER

Sum of the per-minute small read requests metrics per second. This is from cell server statistics.

SMALL_WRITES_SUM

NUMBER

Sum of the per-minute small write requests metrics per second. This is from cell server statistics.

LARGE_READS_SUM

NUMBER

Sum of the per-minute large read requests metrics per second. This is from cell server statistics.

LARGE_WRITES_SUM

NUMBER

Sum of the per-minute large write requests metrics per second. This is from cell server statistics.

SMALL_READ_BYTES_SUM

NUMBER

Sum of the per-minute small read bytes metrics per second. This is from cell server statistics.

SMALL_WRITE_BYTES_SUM

NUMBER

Sum of the per-minute small write bytes metrics per second. This is from cell server statistics.

LARGE_READ_BYTES_SUM

NUMBER

Sum of the per-minute large read bytes metrics per second. This is from cell server statistics.

LARGE_WRITE_BYTES_SUM

NUMBER

Sum of the per-minute large write bytes metrics per second. This is from cell server statistics.

SMALL_READ_LATENCY_SUM

NUMBER

Sum of the per-minute small read latency metrics. This data is from cell server statistics.

SMALL_WRITE_LATENCY_SUM

NUMBER

Sum of the per-minute small write latency metrics. This data is from cell server statistics.

LARGE_READ_LATENCY_SUM

NUMBER

Sum of the per-minute large read latency metrics. This data is from cell server statistics.

LARGE_WRITE_LATENCY_SUM

NUMBER

Sum of the per-minute large write latency metrics. This data is from cell server statistics.

APP_IO_REQUESTS_SUM

NUMBER

Sum of the per-minute IOPs metrics. This data is from cell server statistics.

APP_IO_BYTES_SUM

NUMBER

Sum of the per-minute I/O metrics, in megabytes per second. This data is from cell server statistics.

APP_IO_LATENCY_SUM

NUMBER

Sum of the per-minute I/O latency metrics. This data is from cell server statistics.

*_SUMX2

NUMBER

All the previous columns from DISK_UTILIZATION to APP_IO_LATENCY are repeated with the SUMX2 suffix.

This is the sum of squares of the per-minute metrics.

*_AVG

NUMBER

All the previous columns from DISK_UTILIZATION to APP_IO_LATENCY are repeated with the AVG suffix. This is the average of the per-minute metrics.

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