Metrics in the oracle_oci_exadata Namespace for Storage Servers
You can monitor the health, capacity, and performance of the storage
servers in the Exadata Infrastructure by using metrics, alarms, and notifications. This
section describes the metrics emitted by Database Management in the
oracle_oci_exadata namespace for the storage servers in the Exadata
Infrastructure (oci_oracle_exadata_storage_server resource).
Valid alarm intervals for the metrics are 5 minutes or greater due to the frequency at which these metrics are emitted. For information on how to create alarms, see Managing Alarms.
Retention period is set for 90 days. For information on retention periods, see Storage Limits.
Dimensions
The metrics for the storage servers in the Exadata Infrastructure include the following common dimensions.
| Dimension | Description |
|---|---|
resourceId |
The OCID of the storage server. |
resourceName |
The name of the storage server. |
exadataInfrastructureId |
The OCID of the Exadata Infrastructure. |
deploymentType |
The deployment type of the Exadata Infrastructure.
The deployment type is onprem.
|
Metrics
The metrics for storage servers in the Exadata Infrastructure provide in-depth performance details depicting the health of the storage servers.
| Metric Name | Metric Display Name | Unit | Description and Metric Chart Defaults | Collection Frequency | Additional Dimensions |
|---|---|---|---|---|---|
ASMDiskGroupCapacity |
ASM Disk Group Capacity | GB |
The capacity of the ASM disk group. Statistic: Mean Interval: 60 minutes |
60 minutes |
asmInstance diskGroupName cellDiskType[HardDisk|FlashDisk] |
CellCpuUtilization |
Cell CPU Utilization | percent |
The cell server CPU utilization. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
CellDiskAllocatedPercent |
Cell Disk Allocated Percent | percent |
The percentage of space allocated on the cell disk. Statistic: Mean Interval: 60 minutes |
60 minutes |
cellDiskType[HardDisk|FlashDisk] |
CellDiskCapacity |
Cell Disk Capacity | GB |
The capacity of the cell disk. Statistic: Mean Interval: 60 minutes |
60 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskFreeSpace |
Cell Disk Free Space | GB |
The free space available on the cell disk. Statistic: Mean Interval: 60 minutes |
60 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskIOLoad |
Cell Disk I/O Load | count |
The average I/O load to the cell disk. Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskIOUtilization |
Cell Disk I/O Utilization | percent |
The average I/O utilization. Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskLargeReadIOPS |
Cell Disk Large Read IOPS | operations per second |
The average number of I/O operations for reading large blocks from a cell disk. Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskLargeReadResponseTime |
Cell Disk Large Read Response Time | milliseconds per request |
The average response time when reading large blocks from the cell disk. Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskLargeReadThroughput |
Cell Disk Large Read Throughput | MB per second |
The average I/O throughput per second for reading large blocks from a cell disk. Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskLargeWriteIOPS |
Cell Disk Large Write IOPS | operations per second |
The average number of I/O operations for writing large blocks to cell disk. Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskLargeWriteResponseTime |
Cell Disk Large Write Response Time | milliseconds per request |
The average response time when writing large blocks to the cell disk. Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskLargeWriteThroughput |
Cell Disk Large Write Throughput | MB per second |
The average I/O throughput per second for writing large blocks to a cell disk. Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskReadIOPS |
Cell Disk Read IOPS | operations per second |
The average number of read I/O operations per second. Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskReadResponseTime |
Cell Disk Read Response Time | milliseconds per request |
The average response time per read request from cell disks (weighted by the number of requests for small or large blocks). Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskReadThroughput |
Cell Disk Read Throughput | MB per second |
The average I/O throughput per second for reading small or large blocks from a cell disk. Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskSmallReadIOPS |
Cell Disk Small Read IOPS | operations per second |
The average number of I/O operations for reading small blocks from a cell disk. Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskSmallReadResponseTime |
Cell Disk Small Read Response Time | milliseconds per request |
The average response time when reading small blocks from the cell disk. Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskSmallReadThroughput |
Cell Disk Small Read Throughput | MB per second |
The average I/O throughput per second for reading small blocks from a cell disk. Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskSmallWriteIOPS |
Cell Disk Small Write IOPS | operations per second |
The average number of I/O operations for writing small blocks to cell disk. Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskSmallWriteResponseTime |
Cell Disk Small Write Response Time | milliseconds per request |
The average response time when writing small blocks to the cell disk. Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskSmallWriteThroughput |
Cell Disk Small Write Throughput | MB per second | The average I/O throughput per second for writing
small blocks to a cell disk.
Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskWriteIOPS |
Cell Disk Write IOPS | operations per second |
The average number of write I/O operations per second. Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskWriteResponseTime |
Cell Disk Write Response Time | milliseconds per request |
The average response time per write request to the cell disk (weighted by the number of requests for small or large blocks). Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellDiskWriteThroughput |
Cell Disk Write Throughput | MB per second |
The average I/O throughput per second for writing small or large blocks to a cell disk. Statistic: Mean Interval: 15 minutes |
15 minutes |
cellDiskType[HardDisk|FlashDisk] cellDiskName |
CellMemoryUtilization |
Cell Memory Utilization | percent |
The cell server memory utilization. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
CellOpenAlertCount |
Cell Open Alert Count | count |
The number of cell server open alerts. Statistic: Mean Interval: 15 minutes |
15 minutes |
severity[warning|info|critical] |
CellServerStatus |
Cell Server Status | NA |
The status of the cell server. Statistic: Min Interval: 2 minutes |
2 minutes | None |
DatabaseFlashCacheUsage |
Database Flash Cache Usage | MB |
The database flash cache usage. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseFlashDiskIOPS |
Database Flash Disk IOPS | operations per second |
The database I/O operations per second for reading or writing blocks from flash disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseFlashDiskIOResponseTime |
Database Flash Disk Response Time | milliseconds per request |
The database I/O response time per request for flash disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseFlashDiskIORMWaitTime |
Database Flash Disk IORM Wait Time | milliseconds per request |
The database IORM wait time per request issued to flash disks (weighted by number of requests for small or large blocks). Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseFlashDiskIOThroughput |
Database Flash Disk I/O Throughput | MB per second |
The database I/O throughput for reading or writing from flash disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseFlashDiskIOUtilization |
Database Flash Disk I/O Utilization | percent |
The database I/O utilization for flash disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseFlashDiskLargeIOIORMWaitTime |
Database Flash Disk Large I/O IORM Wait Time | milliseconds per request |
The database IORM wait time per request for large I/O requests issued to flash disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseFlashDiskLargeIOPS |
Database Flash Disk Large IOPS | operations per second |
The database I/O operations per second for reading or writing large blocks from flash disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseFlashDiskLargeIOResponseTime |
Database Flash Disk Large I/O Response Time | milliseconds per request |
The database I/O response time per request for reading or writing large blocks from flash disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseFlashDiskLargeIOUtilization |
Database Flash Disk Large I/O Utilization | percent |
The database I/O utilization for reading or writing large blocks from flash disks Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseFlashDiskSmallIOIORMWaitTime |
Database Flash Disk Small I/O IORM Wait Time | milliseconds per request |
The database IORM wait time per request for small I/O requests issued to flash disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseFlashDiskSmallIOPS |
Database Flash Disk Small IOPS | operations per second |
The database I/O operations per second for reading or writing small blocks from flash disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseFlashDiskSmallIOResponseTime |
Database Flash Disk Small I/O Response Time | milliseconds per request |
The database I/O response time per request for reading or writing small blocks from flash disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseFlashDiskSmallIOUtilization |
Database Flash Disk Small I/O Utilization | percent |
The database I/O utilization for reading or writing small blocks from flash disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseHardDiskIOPS |
Database Hard Disk IOPS | operations per second |
The database I/O operations per second for reading or writing blocks from hard disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseHardDiskIOResponseTime |
Database Hard Disk Response Time | milliseconds per request |
The database I/O response time per request for hard disks (weighted by number of requests for small or large blocks). Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseHardDiskIORMWaitTime |
Database Hard Disk IORM Wait Time | milliseconds per request |
The database IORM wait time per request issued to hard disks (weighted by number of requests for small or large blocks). Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseHardDiskIOThroughput |
Database Hard Disk I/O Throughput | MB per second |
The database I/O throughput for reading or writing from hard disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseHardDiskIOThroughput |
Database Hard Disk I/O Throughput | MB per second |
The database I/O throughput for reading or writing from hard disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseHardDiskIOUtilization |
Database Hard Disk I/O Utilization | percent |
The database I/O utilization for hard disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseHardDiskLargeIOIORMWaitTime |
Database Hard Disk Large I/O IORM Wait Time | milliseconds per request |
The database IORM wait time per request for large I/O requests issued to hard disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseHardDiskLargeIOPS |
Database Hard Disk Large IOPS | operations per second |
The database I/O operations per second for reading or writing large blocks from hard disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseHardDiskLargeIOResponseTime |
Database Hard Disk Large I/O Response Time | milliseconds per request |
The database I/O response time per request for reading or writing large blocks from hard disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseHardDiskLargeIOUtilization |
Database Hard Disk Large I/O Utilization | percent |
The database I/O utilization for reading or writing large blocks from hard disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseHardDiskSmallIOIORMWaitTime |
Database Hard Disk Small I/O IORM Wait Time | milliseconds per request |
The database IORM wait time per request for small I/O requests issued to hard disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseHardDiskSmallIOPS |
Database Hard Disk Small IOPS | operations per second |
The database I/O operations per second for reading or writing small blocks from hard disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseHardDiskSmallIOResponseTime |
Database Hard Disk Small I/O Response Time | milliseconds per request |
The database I/O response time per request for reading or writing small blocks from hard disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
DatabaseHardDiskSmallIOUtilization |
Database Hard Disk Small I/O Utilization | percent |
The database I/O utilization for reading or writing small blocks from hard disks. Statistic: Mean Interval: 15 minutes |
15 minutes |
databaseName type [db] |
FlashCacheFirstWritesPerSecond |
Flash Cache First Writes Per Second | requests per second |
The number of requests to write new data into flash cache. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashCacheHitRatio |
Flash Cache Hit Ratio | percent |
The flash cache read hit ratio. Note: If there's no flash cache activity, then the hit ratio is defaulted to 100%. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashCacheKeepHitRatio |
Flash Cache Hit Ratio for Keep Objects | percent |
The flash cache read hit ratio for keep objects. Note: If there's no flash cache activity, then the hit ratio is defaulted to 100%. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashCacheKeepMisses |
Flash Cache Reads Misses for Keep Objects | count |
The number of read requests for keep objects that did not find all the data in flash cache. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashCacheKeepOverwrites |
Flash Cache Keep Overwrites Per Second | MB per second |
The number of megabytes per second pushed out of flash cache because of the space limit for keep objects. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashCacheKeepReads |
Flash Cache Reads Hits for Keep Objects | count |
The number of requests read from flash cache for keep objects. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashCacheLargeReadThroughput |
Flash Cache Large Read Throughput | MB per second |
The I/O throughput reading large blocks from flash cache. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashCacheOverwritesPerSecond |
Flash Cache Overwrites Per Second | requests per second |
The number of requests that overwrite existing data into flash cache. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashCachePopulationWritesPerSecond |
Flash Cache Population Writes Per Second | requests per second |
The number of requests that are population writes into flash cache due to read miss. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashCacheRandomIOReadPerSecond |
Flash Cache Random I/O Read Per Second | requests per second |
The number of requests to read random I/O from flash cache. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashCacheScanDataReadFromDiskThroughput |
Flash Cache Scan Data Redirected to Disk Read Throughput | MB per second |
The I/O throughput reading scan data from disk, as not all the data is in flash cache. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashCacheScanDataReadPerSecond |
Flash Cache Scan Data Read Per Second | requests per second |
The number of requests to read scan data from flash cache. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashCacheSize |
Flash Cache Size | GB |
The size of flash cache. Statistic: Mean Interval: 15 minutes |
24 hours | None |
FlashCacheSmallReadThroughput |
Flash Cache Small Read Throughput | MB per second |
The I/O throughput reading small blocks from flash cache. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashCacheSmallRequestsHitRatio |
Flash Cache Hit Ratio for Small Requests | percent |
The flash cache read hit ratio for small requests. Note: If there's no flash cache activity, then the hit ratio is defaulted to 100%. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashCacheWriteToHardDisksPerSecond |
Flash Cache Write To Hard Disks Per Second | requests per second |
The number of requests that write data to hard disk from flash cache. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashDiskUsageAllocatedToGridDisk |
Flash Disk Usage Allocated To Grid Disk | GB |
The flash disk space allocated to grid disks. Statistic: Mean Interval: 60 minutes |
60 minutes | None |
FlashDiskUsageForFlashCacheKeep |
Flash Disk Usage For Flash Cache Keep Objects | GB |
The flash disk usage for flash cache keep objects. Statistic: Mean Interval: 60 minutes |
60 minutes | None |
FlashDiskUsageForFlashCacheNonKeep |
Flash Disk Usage For Flash Cache Non-Keep Objects | GB |
The flash disk usage for flash cache non-keep objects. Statistic: Mean Interval: 60 minutes |
60 minutes | None |
FlashDiskUsageForFlashCacheUnused |
Flash Disk Usage For Flash Cache Unused | GB |
The flash disk usage for flash cache that is unused. Statistic: Mean Interval: 60 minutes |
60 minutes | None |
FlashDiskUsageForFlashLog |
Flash Disk Usage For Flash Log | GB |
The flash disk usage for flash log. Statistic: Mean Interval: 60 minutes |
60 minutes | None |
FlashDiskUsageForMetadata |
Flash Disk Usage For Metadata | GB |
The flash disk usage for metadata. Statistic: Mean Interval: 60 minutes |
60 minutes | None |
FlashLogActualOutliers |
Flash Log Actual Outliers | NA |
The number of redo writes exceeding the outlier threshold. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashLogEfficiencyPastHour |
Flash Log Efficiency for Past Hour | percent |
The smart flash logging efficiency over the past hour. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashLogPreventedOutliers |
Flash Log Prevented Outliers | NA |
The number of redo writes that are prevented from exceeding the outlier threshold. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashLogSkippedWritesDueToLargeWrite |
Flash Log Skipped Writes Due to Large Write | count |
The number of redo writes that are bypassed due to the size of data being greater than the available space. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashLogSkippedWritesDueToNoBuffer |
Flash Log Skipped Writes Due to No Buffer | count |
The number of redo writes that are bypassed due to unavailable buffer. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashLogSkippedWritesDueToSlowDisk |
Flash Log Skipped Writes Due to Slow Disk | count |
The number of redo writes that are bypassed due to slow disk. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashLogWritesServiced |
Flash Log Writes Serviced | operations per second |
The number of Smart Flash Logging writes serviced. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
FlashLogWriteThroughput |
Flash Log Throughput | MB per second |
The Smart Flash Logging write throughput. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
HardDiskUsageAllocatedToGridDisk |
Hard Disk Usage Allocated to Grid Disks | GB |
The hard disk usage allocated to grid disks. Statistic: Mean Interval: 60 minutes |
60 minutes | None |
HardDiskUsageForMetadata |
Hard Disk Usage For Metadata | GB |
The hard disk space used for metadata. Statistic: Mean Interval: 60 minutes |
60 minutes | None |
InfinibandThroughput |
Infiniband Throughput | MB per second |
The megabytes transmitted or received through the Infiniband interface. Statistic: Mean Interval: 15 minutes |
15 minutes |
operationType=[sent|received] |
IORMBoost |
IORM Boost | percent |
The ratio of the cumulative number of positions in the I/O queue that were skipped. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
IORMMode |
IORM Mode | GB |
The current I/O resource management mode. Note that
if IORM objective = Statistic: Mean Interval: 15 minutes |
15 minutes | None |
IORMObjective |
IORM Objective | NA |
The I/O resource management objective. Statistic: Mean Interval: 60 minutes |
60 minutes | None |
ManagementServiceStatus |
Management Service Status | NA |
The status of the storage server's management service. Statistic: Min Interval: 2 minutes |
2 minutes | None |
SmartScanIOFlashDiskReadThroughput |
Smart Scan I/O Flash Disk Read Throughput | MB per second |
The megabytes read from the flash disk by the Smart Scan I/O. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
SmartScanIOHardDiskReadThroughput |
Smart Scan I/O Hard Disk Read Throughput | MB per second |
The megabytes read from the hard disk by the Smart Scan I/O. Statistic: Mean Interval: 15 minutes |
15 minutes | None |
SmartScanIOPassThroughThroughput |
Smart Scan I/O Pass Through Throughput | MB per second |
The megabytes of Smart Scan I/O pass-through (sent back to the database for processing). Statistic: Mean Interval: 15 minutes |
15 minutes | None |
SmartScanIOStorageIndexThroughput |
Smart Scan I/O Throughput Saved by Storage Index | MB per second |
The megabytes saved or avoided by using Storage Index. Statistic: Mean Interval: 15 minutes |
15 minutes | None |