Exadata Disk Daily

This data object contains aggregated storage server (cell) daily summary data for hard and flash disks.

Table 17-25 Exadata Disk Daily

Field Name Name Column Type Column Category Description
DAY_OF_WEEK Collection day of week VARCHAR2 DIMENSION Collection day in weekly range 1-7 (Mon-Sun)
DAY_OF_MONTH Collection day of month VARCHAR2 DIMENSION Collection day in monthly range 1-31
ROLLUP_TIME_UTC Rollup time (UTC) TIMESTAMP TIME_DIMENSION End timestamp of the rollup period (UTC)
HOUR_OF_DAY Collection hour of day VARCHAR2 DIMENSION Collection hour in hourly range 0-23
OPSI_ID Exadata insight OCID VARCHAR2 DIMENSION Exadata insight resource OCID
CELL_DISPLAY_NAME Cell display name VARCHAR2 DIMENSION Cell unique identifier
CELL_NAME Cell name VARCHAR2 DIMENSION Cell name
CELL_ID Cell OPSI unique identifier VARCHAR2 DIMENSION Cell unique identifier
CELL_VERSION Cell version VARCHAR2 DIMENSION Kernel version of the cell
EXADATA_NAME Exadata insight resource name VARCHAR2 DIMENSION Exadata insight resource name
EXADATA_TYPE Exadata insight resource type VARCHAR2 DIMENSION Exadata insight resource type
EXADATA_DISPLAY_NAME Exadata insight resource display name VARCHAR2 DIMENSION Exadata insight resource display name
SOURCE_IDENTIFIER Telemetry source identifier VARCHAR2 DIMENSION Enterprise Manager GUID or Management Agent OCID (identifier for where the telemetry is being collected)
SOURCE_ENTITY_IDENTIFIER Telemetry source entity identifier VARCHAR2 DIMENSION Enterprise Manager target GUID for the cell
PDIOPS_CAP Physical disk maximum IO operations NUMBER DIMENSION Maximum number of input/output operations per second from the physical disk
FDIOPS_CAP Flash disk maximum IO operations NUMBER DIMENSION Maximum number of input/output operations per second from the flash disk
PDMBPS_CAP Physical disk maximum data transfer rate in MB/s NUMBER DIMENSION Maximum number of megabytes per second from the physical disk
FDMBPS_CAP Flash disk maximum data transfer rate in MB/s NUMBER DIMENSION Maximum number of megabytes per second from the flash disk
CELLDISK_TYPE Cell disk type VARCHAR2 DIMENSION Type of disk with available options: FlashDisk, HardDisk and PMEM
TOTAL_CD_READ_IOPS Total cell disk read IO operations NUMBER METRIC Total number of read requests per second across all cell disks in a cell
TOTAL_CD_WRITE_IOPS Total cell disk write IO operations NUMBER METRIC Total number of write requests per second across all cell disks in a cell
TOTAL_CD_READ_THROUGHPUT Total cell disk read throughput NUMBER METRIC Total number of megabytes read per second from all cell disks in a cell
TOTAL_CD_WRITE_THROUGHPUT Total cell disk write throughput NUMBER METRIC Total number of megabytes written per second to all cell disks in a cell
AVG_CD_IO_UTIL Average cell disk IO utilization NUMBER METRIC Average percent of device utilization across all cell disks in a cell
AVG_CD_WRITE_LATENCY Average cell disk write response time NUMBER METRIC Average latency (in milliseconds) of writing blocks per request to a cell disk, across all cell disks in a cell
AVG_CD_READ_LATENCY Average cell disk read response time NUMBER METRIC Average latency (in milliseconds) of reading blocks per request from a cell disk, across all cell disks in a cell
TOTAL_CD_IO_LOAD Total cell disk IO load NUMBER METRIC Total input/output load across all cell disks in a cell
AVG_CD_READ_THROUGHPUT Average cell disk read throughput NUMBER METRIC Number of megabytes read per second from a cell disk, averaged across all cell disks in a cell
AVG_CD_WRITE_THROUGHPUT Average cell disk write throughput NUMBER METRIC Number of megabytes written per second to a cell disk, averaged across all cell disks in a cell
AVG_CD_READ_IOPS Average cell disk read IO operations NUMBER METRIC Number of read requests per second from a cell disk, averaged across all cell disks in a cell
AVG_CD_WRITE_IOPS Average cell disk write IO operations NUMBER METRIC Number of write requests per second to a cell disk, averaged across all cell disks in a cell
AVG_CD_IO_LOAD Average cell disk IO load NUMBER METRIC Average input/output load across all cell disks in a cell
AVG_CD_SM_R_LATENCY Average cell disk small read response time NUMBER METRIC Average response time (in milliseconds) when reading small blocks from the cell disk
AVG_CD_SM_W_LATENCY Average cell disk small write response time NUMBER METRIC Average response time (in milliseconds) when writing small blocks to the cell disk
MAX_CD_SM_R_LATENCY Maximum cell disk small read response time NUMBER METRIC Maximum response time (in milliseconds) when reading small blocks from the cell disk
MAX_CD_SM_W_LATENCY Maximum cell disk small write response time NUMBER METRIC Maximum response time (in milliseconds) when writing small blocks to the cell disk
AVG_CD_SMALL_READ_THROUGHPUT Average cellDisk small read throughput NUMBER METRIC Average MBs read per second from small blocks in a cell disk
AVG_CD_LARGE_READ_THROUGHPUT Average cell disk large read throughput NUMBER METRIC Average MBs read per second from large blocks in a cell disk
AVG_CD_SMALL_WRITE_THROUGHPUT Average cell disk small write throughput NUMBER METRIC Average MBs written per second from small blocks in a cell disk
AVG_CD_LARGE_WRITE_THROUGHPUT Average cell disk large write throughput NUMBER METRIC Average MBs written per second from large blocks in a cell disk
AVG_CD_SMALL_READ_IOPS Average cell disk small read IO operations NUMBER METRIC Average number of input/output operations read per second from small blocks in a cell disk
AVG_CD_LARGE_READ_IOPS Average cell disk large read IO operations NUMBER METRIC Average number of input/output operations read per second from large blocks in a cell disk
AVG_CD_SMALL_WRITE_IOPS Average cell disk small write IO operations NUMBER METRIC Average number of input/output operations written per second from small blocks in a cell disk
AVG_CD_LARGE_WRITE_IOPS Average cell disk large write IO operations NUMBER METRIC Average number of input/output operations written per second from large blocks in a cell disk
AVG_CD_LG_R_LATENCY Average cell disk large read response time NUMBER METRIC Average response time (in milliseconds) to read large blocks from the cell disk
AVG_CD_LG_W_LATENCY Average cell disk large write response time NUMBER METRIC Average response time (in milliseconds) to read large blocks from the cell disk
TOTAL_CD_IO_UTIL Total cell disk IO utilization NUMBER METRIC Total percent of device utilization for input/output across all cell disks in a cell