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 |
---|---|---|---|
|
NUMBER |
NOT NULL |
Unique snapshot identifier. |
|
NUMBER |
NOT NULL |
Database identifier for the snapshot. |
|
NUMBER |
NOT NULL |
Hash number to uniquely identify the cell. |
|
NUMBER |
NOT NULL |
Unique identifier of the disk. |
|
NUMBER |
Number of one-minute samples the summary is based on. |
|
|
NUMBER |
Sum of the per-minute disk utilization metrics. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute read requests metrics per second. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute read metrics, in megabytes per second. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute write requests metrics, per second. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute write metrics, in megabytes per second. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute IOPs. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute I/O metrics, in megabytes per second. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute service time metrics. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute wait time metrics. This is based on OS statistics. |
|
|
NUMBER |
Sum of the per-minute small read requests metrics per second. This is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute small write requests metrics per second. This is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute large read requests metrics per second. This is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute large write requests metrics per second. This is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute small read bytes metrics per second. This is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute small write bytes metrics per second. This is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute large read bytes metrics per second. This is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute large write bytes metrics per second. This is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute small read latency metrics. This data is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute small write latency metrics. This data is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute large read latency metrics. This data is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute large write latency metrics. This data is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute IOPs metrics. This data is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute I/O metrics, in megabytes per second. This data is from cell server statistics. |
|
|
NUMBER |
Sum of the per-minute I/O latency metrics. This data is from cell server statistics. |
|
|
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. |
|
|
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. |
|
|
NUMBER |
The database identifier. |
|
|
NUMBER |
The identifier of the container identified by CON_DBID. Possible values are as follows:
|
Parent topic: Automatic Workload Repository Views