Oracle Exadata Storage Server Grid Performance Metrics

The following performance metrics are available for Oracle Exadata Storage Server Grid:

Exadata Database Flash Disk I/O Statistics

Description: This metric provides aggregated Flash Disk I/O stats related to database

Collection Frequency: 15 minutes. This metric is disabled out of the box.

Metric Column	Description
Database	Database Name
I/O Utilization (%)	I/O Utilization (%)
Average I/O Wait Time (us/req)	Average I/O Wait Time (us/req)
Average I/O Throughput (MB/sec)	Average I/O Throughput (MB/sec)
Average Small Block Read/Write Latency (us/req)	Average Small Block Read/Write Latency (us/req)
I/O Request Rate(req/sec)	I/O Request Rate(req/sec)

Exadata Key Performance Indicators

The following key performance indicator metrics are displayed for the Exadata Storage Server Grid:

Exadata PDB Flash Disk I/O Statistics

Description: Flash disk I/O statistics for pluggable database.

Collection Frequency: 15 minutes. This metric is disabled out of the box.

Metric Column	Description
Pluggable Database	Pluggable database name
I/O Utilization (%)	I/O Utilization (%)
Average I/O Wait Time (us/req)	Average I/O Wait Time (us/req)
Average I/O Throughput (MB/sec)	Average I/O throughput (MB/sec)
Average Small Block Read/Write Latency (us/req)	Average Small Block Read/Write Latency (us/req)
I/O Request Rate (req/sec)	I/O Request Rate (req/sec)

Response

This metric category contains the metric used to detect the response of the Oracle Exadata Storage Server Grid target.

Target Version: All versions

Collection Frequency: Event-driven

Metric	Description
Status	This metric's collection frequency is event-driven. A one in the status column indicates that the target is up, otherwise it is down.

Metric	Description	Alert Message	Clear Message
Exadata Key Performance Indicators	Key performance indicators for the Exadata Storage Server Grid.	-	-
Total Capacity-Optimized Flash Disk IOPS	Aggregated total read and write IOPS of all capacity-optimized flash disks on the Exadata Storage Server Grid	-	-
Total Capacity-Optimized Flash Disk Throughput	Aggregated total read and write throughput of all capacity-optimized flash disks on the Exadata Storage Server Grid	-	-
Average Capacity-Optimized Flash Disk IO Load	Average IO load across all capacity-optimized flash disks on the Exadata Storage Server Grid	-	-
Average Capacity-Optimized Flash Disk Response Time	Average read and write latency across all capacity-optimized flash disks on the Exadata Storage Server Grid	-	-
Capacity-Optimized Flash Disk IO Health Exceptions	Number of capacity-optimized flash disks health exceptions on the Exadata Storage Server Grid.	-	-
Total Flash Disk IOPS	Aggregated total read and write IOPS of all flash disks on the Exadata Storage Server Grid.	Total flash disk IOPS for %target% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold.	Total flash disk IOPS for %target% is %value%, fallen below warning (%warning_threshold%) or critical (%critical_threshold%) threshold.
Total Hard Disk IOPS	Aggregated total read and write IOPS of all hard disks on the Exadata Storage Server Grid.	Total hard disk IOPS for %target% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold.	Total hard disk IOPS for %target% is %value%, fallen below warning (%warning_threshold%) or critical (%critical_threshold%) threshold.
Total Flash Disk Throughput	Aggregated total read and write throughput of all flash disks on the Exadata Storage Server Grid.	Total flash disk throughput for %target% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold.	Total flash disk throughput for %target% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold.
Total Hard Disk Throughput	Aggregated total read and write throughput of all hard disks on the Exadata Storage Server Grid.	Total hard disk throughput for %target% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold.	Total hard disk throughput for %target% is %value%, fallen below warning (%warning_threshold%) or critical (%critical_threshold%) threshold.
Average Flash Disk IO Load	Average IO load across all flash disks on the Exadata Storage Server Grid.	Average flash disk IO load for %target% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold.	Average flash disk IO load for %target% is %value%, fallen below warning (%warning_threshold%) or critical (%critical_threshold%) threshold.
Average Hard Disk IO Load	Average IO load across all hard disks on the Exadata Storage Server Grid.	Average hard disk IO load for %target% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold.	Average hard disk IO load for %target% is %value%, fallen below warning (%warning_threshold%) or critical (%critical_threshold%) threshold.
Average Flash Disk Response Time	Average read and write latency across all flash disks on the Exadata Storage Server Grid.	Average flash disk response time for %target% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold.	Average flash disk response time for %target% is %value%, fallen below warning (%warning_threshold%) or critical (%critical_threshold%) threshold.
Average Hard Disk Response Time	Average read and write latency across all hard disks on the Exadata Storage Server Grid.	Average hard disk response time for %target% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold.	Total hard disk response time for %target% is %value%, fallen below warning (%warning_threshold%) or critical (%critical_threshold%) threshold.
Flash Disk IO Health Exceptions	Number of members whose Exadata Key Performance Indicator Flash Disk IO Health Exceptions exceed their critical thresholds.	%target% has %value% member Exadata Storage Servers whose Key Performance Indicator Flash Disk IO Health Exceptions exceed their critical thresholds.	%target% has %value% member Exadata Storage Servers whose Key Performance Indicator Flash Disk IO Health Exceptions exceed their critical thresholds.
Hard Disk IO Health Exceptions	Number of members whose Exadata Key Performance Indicator Hard Disk IO Health Exceptions exceed their critical thresholds.	%target% has %value% member Exadata Storage Servers whose Key Performance Indicator Hard Disk IO Health Exceptions exceed their critical thresholds.	%target% has %value% member Exadata Storage Servers whose Key Performance Indicator Hard Disk IO Health Exceptions exceed their critical thresholds.