9 Oracle Exadata
For each metric, it provides the following information:
-
Description
-
Metric table
The metric table can include some or all of the following: target version, default collection frequency, default warning threshold, default critical threshold, and alert text.
It includes the metrics collected for the following target types:
Oracle Exadata Storage Server
The Oracle Exadata target monitors the software and hardware performance of an individual Oracle Exadata Storage Server in the database.
Aggregated Exadata Capacity
This metric category contains the aggregated metrics of the Exadata Capacity metric category and it collects every 60 minutes.
Disk Size (GB)
This metric gives an indication of the size of the status in GB.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 60 Minutes |
Disk Type
This metric reports the metrics are for hard disk, flash disk, flash cache, and grid disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 60 Minutes |
Aggregated Exadata CellDisk
This metric category contains the aggregated cell disk performance metrics. The metric values are aggregated over all the cell disks in a cell. They are mainly aggregated via averaging and totaling.
Average CellDisk IO Load
This metric gives an indication of the average input/output load to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Read IOPS
This metric gives an indication of the average number of read input/output operations per second.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Read Response Time
This metric gives an indication of the average read response time to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Read Throughput
This metric gives an indication of the average number of bytes read from the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Write IOPS
This metric gives an indication of the average number of write input/output operations to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Write Response Time
This metric gives an indication of the average write response time to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Write Throughput
This metric gives an indication for the average number of bytes written to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Maximum CellDisk IO Load
This metric gives an indication of the maximum input/output load to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Total CellDisk Read Throughput
This metric gives an indication for the total number of bytes read from the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Total CellDisk Write IOPS
This metric gives an indication of the total number of write input/output operations per second to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Total CellDisk Write Throughput
This metric gives an indication of the total number of bytes written to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Total CellDisk IO Load
This metric gives an indication of the total input/output load to the celldisk. The Total CellDisk IO load is the aggregated number of IO requests waiting to be serviced by the storage server disks at any given point in time. You can think of this as the length of the queue for I/O requests.
Because the type of requests can be either for small or large reads, there is not one number that would indicate a potential performance issue. Oracle cannot recommend a number as each customer environment is often unique. Monitor the value of the I/O load and a number that correlates with poor response time will be a good candidate for a metric threshold. An Exadata system is underutilized if the I/O load is less than 20.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Aggregated Exadata Diskgroup Capacity
This metric category contains the aggregated capacity metrics for ASM instances and disk groups.
ASM Instance
This metric reports the ASM instance name for the aggregated exadata diskgroup.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 60 Minutes |
Count
This metric reports the total grid disk number for the specific diskgroup.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 60 Minutes |
Diskgroup Name
This metric reports the name of the aggregated exadata diskgroup.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 60 Minutes |
Aggregated Exadata FlashDisk and HardDisk
This metric category contains metrics that are aggregated over either the hard disks or flash disks in a cell.
Average CellDisk IO Load
This metric reports the average input and output load to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Large Read IOPS
This metric indicates the average number of read input and output operations from large blocks in a cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk IO Utilization
This metric indicates the average utilization for I/O requests from the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Large Read Response Time
This metric reports the average response time to read large blocks from the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Large Read Throughput
This gives an indication of the average number of bytes read from the large blocks from the hard disks or flash disks in a cell.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Large Write IOPS
This gives an indication of the average number of input and output operations written to large blocks of the hard disks or flash disks in a cell.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Large Write Response Time
This gives an indication of the average response time when writing large blocks to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Large Write Throughput
This gives an indication of the total number of bytes when writing large blocks to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Read IOPS
This metric gives an indication of the average number of read input/output operations from the hard disks or flash disks in a cell.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Read Response Time
This metric reports the average read response time to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Read Throughput
This metric gives an indication of the average number of bytes read from the hard disks or flash disks in a cell.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Small Read IOPS
This gives an indication of the average number of read input and output operations from small blocks in a cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Small Read Response Time
This metric reports the average response time when reading small blocks from the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Small Read Throughput
This gives an indication of the average number of bytes read from the small blocks from the hard disks or flash disks in a cell.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Small Write IOPS
This gives an indication of the average number of input and output operations written to small blocks of the hard disks or flash disks in a cell.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Small Write Response Time
This metric reports the average response time when writing small blocks to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Small Write Throughput
This gives an indication of the total number of bytes when writing small blocks to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Write IOPS
This metric gives an indication of the average number of input/output operations written to the hard disks or flash disks in a cell.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 5 Minutes |
Average CellDisk Write Response Time
This metric reports the average response time when writing to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average CellDisk Write Throughput
This metric gives an indication of the average number of bytes written to the hard disks or flash disks in a cell.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
CellDisk Type
This metric reports the type of Cell disk, either hard disk or flash disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Maximum CellDisk Small Read Response Time
This metric reports the maximum response time when reading small blocks from the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Maximum CellDisk Small Write Response Time
This metric reports the maximum response time when writing small blocks to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Total CellDisk IO Load
This metric reports the total input/output load to the celldisk. The Total CellDisk IO load is the aggregated number of IO requests waiting to be serviced by the storage server disks at any given point in time. You can think of this as the length of the queue for I/O requests.
Because the type of requests can be either for small or large reads, there is not one number that would indicate a potential performance issue. Oracle cannot recommend a number as each customer environment is often unique. Monitor the value of the I/O load and a number that correlates with poor response time will be a good candidate for a metric threshold. An Exadata system is underutilized if the I/O load is less than 20.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Total CellDisk IO Utilization
This metric reports the total utilization for I/O requests to the celldisk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Total CellDisk Read IOPS
This metric reports the total number of bytes read from the hard disks or flash disks in a cell.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Total CellDisk Read Throughput
This metric reports the total number of bytes read from the hard disks or flash disks in a cell.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Total CellDisk Write IOPS
This metric reports the total number of bytes written to the hard disks or flash disks in a cell.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Cell Generated Alert
This metric category contains the cell generated alert metrics. This is shown whenever the Exadata Storage server (cell) generates alert and the Enterprise Manager subscribes to the cell's SNMP alert.
Action
This metric shows the recommended action to perform for this alert.
Target Version | Collection Frequency |
---|---|
11g, 12c |
N/A |
ADR Incident ID
This metric shows the alert Automatic Diagnostic Repository (ADR) unique identifier for Enterprise Manager Incident Manager.
Target Version | Collection Frequency |
---|---|
11g, 12c |
N/A |
ADR Problem Key
This metric shows the alert ADR problem key.
Target Version | Collection Frequency |
---|---|
11g, 12c |
N/A |
ADR Trace File Name
This metric shows the Alert ADR Trace file.
Target Version | Collection Frequency |
---|---|
11g, 12c |
N/A |
Alert Begin Time
This metric shows the time stamp when an alert changes its state.
Target Version | Collection Frequency |
---|---|
11g, 12c |
N/A |
Alert Object
This metric shows the Alert Object Name, such as cell disk or grid disk, for which a metric threshold has caused an alert.
Target Version | Collection Frequency |
---|---|
11g, 12c |
N/A |
Alert Name
This metric shows the name of the alert.
Target Version | Collection Frequency |
---|---|
11g, 12c |
N/A |
Alert Sequence
This metric shows the alert sequence.
Target Version | Collection Frequency |
---|---|
11g, 12c |
N/A |
Alert Type
This metric shows the type of the alert. Values are stateful or stateless.
Target Version | Evaluation and Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
11g, 12c |
N/A |
Warning |
Critical |
Alert from %target% is cleared: %msg% |
ECID
This metric shows the Alert ADR Execution Context Id.
Target Version | Collection Frequency |
---|---|
11g, 12c |
N/A |
Examined By
This metric shows the administrator who reviewed the alert.
Target Version | Collection Frequency |
---|---|
11g, 12c |
N/A |
Msg
This metric shows a brief explanation of the alert.
Target Version | Collection Frequency |
---|---|
11g, 12c |
N/A |
Notification
This metric shows the number indicating progress in notifying subscribers to alert messages.
Target Version | Collection Frequency |
---|---|
11g, 12c |
N/A |
Sequence Begin Time
This metric shows the time stamp when an alert sequence ID is first created.
Target Version | Collection Frequency |
---|---|
11g, 12c |
N/A |
Exadata Cell Metric
This metric category contains the performance metrics collected at the cell level for each cell, such as CPU utilization and memory utilization.
Cell Name
This metric reports the exadata cell name.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
CPU Utilization
This metric provides information about the CPU utilization.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
CPU Utilization for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Disk I/O Objective
This metric provides the optimization objective which IORM is configured to achieve. For example, "Low Latency" or "Balanced" for OLTP-oriented databases, or "High Throughput" for data warehouses.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Exadata Run Queue Length
This metric provides information about the Exadata run queue length.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Exadata Run Queue Length for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Exadata Temperature Lower Threshold
This metric reports the lower or minimum temperature threshold for the ambient operating temperature for the Exadata machine.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Exadata Temperature Lower Threshold for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Exadata Temperature Reading
This metric reports the ambient operating temperature for the Exadata machine.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Exadata Temperature Upper Threshold
This metric reports the upper or maximum temperature threshold for the ambient operating temperature for the Exadata machine.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Exadata Temperature Upper Threshold for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
IORM Boost
This metric reports the ratio of the cumulative number of positions in the I/O queue that were skipped because of IORM scheduling to the number of I/Os that were scheduled.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
LED Status
This metric provides the status of the locator LED (on or off).
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Memory Utilization
This metric provides information about the memory utilization.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Memory Utilization for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Network Received
This metric reports the total number of I/O packets received by interconnections per second.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Network Sent
This metric reports the total number of I/O packets transmitted by interconnections per second.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Offload Efficiency
This metric provides information about the offload efficiency.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Offload Efficiency for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Exadata CellDisk Metric
This metric category contains performance metrics for each cell disk. The metric values are collected for each cell disk.
Average Large Read Response Time
This metric reports the average response time to read large blocks from the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average Large Write Response Time
This metric reports the average response time when writing large blocks to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average Read Response Time
This metric reports the average read response time to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average Small Read Response Time
This metric reports the average response time when reading small blocks from the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average Small Write Response Time
This metric reports the average response time when writing small blocks to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average Write Response Time
This metric reports the average response time when writing to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
CellDisk Type
This metric reports the celldisk type, either hard disk or flash disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
IO Load
This metric reports the average input/output load to the cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
IO Utilization
This metric reports the percentage utilization for I/O requests.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Large Read Bytes
This metric reports the number of MB read in large blocks from a cell disk.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Large Read Bytes for %target% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Large Read Requests
This metric reports the number of requests to read large blocks from a cell disk.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Large Read Requests for %target% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Large Write Bytes
This metric reports the number of MB written in large blocks to a cell disk.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Large Write Bytes for %target% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Large Write Requests
This metric reports the number of requests to write large blocks to a cell disk.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Large Write Requests for %target% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Object Name
This metric reports the cell disk name.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Read IOPS
This metric reports the number of read input/outputs per second to a cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Read Throughput (MBPS)
This metric reports the number of bytes in MB per second read from a cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Small Read Bytes
This metric reports the number of MB read in small blocks from a cell disk.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Small Read Bytes for %target% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Small Read Requests
This metric reports the number of requests to read small blocks from a cell disk.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Small Read Requests for %target% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Small Write Bytes
This metric reports the number of MB written in small blocks to a cell disk.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Small Write Bytes for %target% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Small Write Requests
This metric reports the number of requests to write small blocks to a cell disk.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Small Write Requests for %target% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Write IOPS
This metric reports number of write input/outputs operations per second to a cell disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Exadata CellDisk Load Imbalance
This metric category contains the Exadata CellDisk Load Imbalance metrics.
IO Load Imbalance
This metric gives an indication of the percentage of maximum average I/O load from the cell disk.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
CellDisk %object_name% is %cd_io_load_imbalance%% load imbalance, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Exadata Disk Status Metric
This metric category contains the status of the physical Exadata disk.
Disk Status
This metric reports the status of the physical disk.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 1 Hour |
Not Defined |
Not Defined |
Physical Disk Status %target%:%object_name% is %value%, equaled to warning (%warning_threshold%) or critical (%critical_threshold%) value. |
Exadata Flash Cache Metric
This metric category contains the performance metrics for the flash cache in a cell.
Cell Name
This metric provides the name of the Exadata Storage Server on which the flash cache belongs to.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Default Hits
This metric reports the number of read requests satisfied from flash cache non-keep objects since the last metric collection.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Default Hits (%)
This metric reports the percentage of read requests to non-keep objects that are satisfied from flash cache since the last metric collection. Exadata Storage Server automatically decides which objects will be put in flash cache as non-keep objects. In general, the higher the hits rate, the better the performance.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Default hits rate for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Default Misses
This metric reports the number of read requests to non-keep objects which did not find all data in flash cache since the last metric collection.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Default Misses (%)
This metric reports the percentage of read requests to non-keep objects which did not find all data in flash cache since the last metric collection. In general, a low number of read misses indicates better performance. However, in cases where it is not beneficial to put data object of large size into flash cache, a high number of read misses does not necessarily indicate performance issues.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Default misses rate for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Default Read IOPS
This metric reports the number of read requests per second which were satisfied from flash cache non-keep objects.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Default Read Throughput (MBPS)
This metric reports the size of data read per second from flash cache non-keep objects.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Default Used (GB)
This metric reports the space used for non-keep objects on flash cache.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Flash Cache All I/O Requests
This metric reports the cumulative number of read requests to flash cache since the metric was created.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
First Writes
The metric reports the cumulative number of requests to write new data to flash cache since the metric was created.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
First Writes Per Second
The metric reports the number of requests per second to write new data to flash cache since the last metric collection.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Flash Cache I/O Requests Keep Pool Misses
This metric reports the cumulative number of read requests to keep objects which did not find all data in flash cache since the metric was created.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Flash Cache I/O Requests Read Misses
This metric reports the cumulative number of read requests which did not find all data in flash cache since the metric was created.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Flash Cache I/O Requests for keep
This metric reports the cumulative number of read requests to keep objects since the metric was created.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Flash Cache Megabytes Read Misses
This metric reports the cumulative size of data read from disk which did not find all data from Flash Cache since the metric was created.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Flash Cache Megabytes Reads
This metric reports the cumulative size of data read from Flash Cache since the metric was created.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Flash Cache Megabytes Reads for Keep
This metric reports the cumulative size of data read from Flash Cache keep objects since the metric was created.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Flash Cache Read IOPS
This metric reports the number of read requests per second from Flash Cache for small requests since the last metric collection.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Keep Hits
This metric shows the number of read requests satisfied from Flash Cache keep objects since the last metric collection.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Keep Hits (%)
This metric reports the percentage of read requests to keep objects that are satisfied from Flash Cache since the last metric collection. In general, the higher the keep hits rate, the better performance.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Keep hits rate for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Keep Misses
This metric reports the number of read requests to keep objects which did not find all data in Flash Cache since the last metric collection.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Keep Misses (%)
This metric reports the percentage of read requests to keep objects which did not find all data in Flash Cache since the last metric collection. In general, a low number of read misses indicates better performance. However, in cases where it is not beneficial to put data objects of a large size into flash cache, a high number of read misses does not necessarily indicate performance issues.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Keep misses rate for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Keep Pool Read IOPS
This metric reports the number of read requests per second which were satisfied from Flash Cache keep objects.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Keep Pool Read Throughput (MBPS)
This metric reports the size of data read per second from Flash Cache keep objects.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Keep Pool Used (GB)
This metric reports the space used for keep objects on Flash Cache.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Read Throughput (MBPS)
This metric reports the size of data read per second redirected from Flash Cache to disk due to the size of the requested object since the last metric collection.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Requests that are first writes into flash cache
This metric reports the cumulative number of requests to write new data to Flash Cache since the metric was created.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Requests that are overwrites into Flash Cache
This metric reports the cumulative number of requests to overwrite existing data on Flash Cache since the metric was created.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Used (GB)
This metric reports the size of used space on flash cache.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Exadata Flash Log Metric
This metric category contains the Exadata Flash Log metrics.
Cell Name
This metric provides the name of the storage server on which the Flash Log resides.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Efficiency of Smart Flash Logging (%)
This metric provides the efficiency of Smart Flash Logging expressed as a percentage, that is, the ratio between the number of redo log writes completed by Smart Flash Log and the total number of redo log writes.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Exadata IORM Consumer Group Metric
This metric category contains the Exadata IORM Consumer Group metrics.
Average I/O Throughput (MB/Sec)
This metric reports the number of megabytes of I/O per second for this consumer group to hard disks.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average Wait Time for I/O (ms/req)
This metric reports the average IORM wait time per request issued by a consumer group.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Cell Name
This metric reports the name of Exadata Storage Server.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
I/O Requests per Second (IO/sec)
This metric reports the number of IO requests issued by a consumer group to hard disks per second.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Exadata IORM DB
This metric category contains the metrics collected for the IORM databases.
Average I/O Load
This metric reports the average I/O load from this database for hard disks.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average I/O Throughput (MB/Sec)
This metric reports the number of megabytes of I/O per second for this database to hard disks.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average Wait Time for I/O (ms/req)
This metric reports the average wait time for I/O requests.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Average Throttle Time per Disk I/O by Database for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Average Wait Time for Large I/O (ms/req)
This metric reports the average wait time for large I/O requests.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Average IORM wait time of Large Request in seconds for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Average Wait Time for Small I/O (ms/req)
This metric reports the average wait time for small I/O requests.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Average IORM wait time of Small Request in seconds for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Average latency of reading or writing blocks/request from flash disks
This metric reports the rate which is the average latency of reading or writing blocks per request by a database from flash disks.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average latency of reading blocks/request from hard disks
This metric reports the rate which is the average latency of reading blocks per request by a database from hard disks.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average latency of reading large blocks/request from hard disks
This metric reports the rate which is the average latency of reading large blocks per request by a database from hard disks.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average latency of reading small blocks/request from hard disks
This metric reports the rate which is the average latency of reading small blocks per request by a database from hard disks.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Cell Name
This metric provides a character string (maximum 400) that specifies the IP addresses of the cell.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Cumulative latency of reading blocks from flash disks
This metric reports the cumulative latency of reading blocks by a database from flash disks.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Cumulative latency of reading large blocks from hard disks
This metric reports the cumulative latency of reading large blocks by a database from hard disks.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Cumulative latency of reading small blocks from hard disks
This metric reports the cumulative latency of reading small blocks by a database from hard disks.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
I/O Requests per Second (IO/Sec)
This metric reports the number of IO requests issued by a database to hard disks per second.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
I/O Requests per Second - Large (IO/Sec)
This metric reports the number of large IO requests issued by a database to hard disks per second.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
I/O Requests per Second - Small (IO/Sec)
This metric reports the number of small IO requests issued by a database to hard disks per second.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
IO Utilization (%)
This metric reports the percentage utilization for I/O requests.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Large I/O Utilization (%)
This metric reports the percentage utilization for large I/O requests.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Database IO Utilization for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Small IO Utilization (%)
This metric reports the percentage utilization for small I/O requests.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Wait Time for Large I/O (ms)
This metric specifies the average number of milliseconds that large I/O requests issued by the database have waited to be scheduled by IORM in the past minute. A large value indicates that the I/O workload from this database is exceeding the allocation specified for it in the interdatabase plan.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Wait Time of Large Requests for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Wait Time for Small I/O (ms)
This metric specifies the average number of milliseconds that small I/O requests issued by the database have waited to be scheduled by IORM in the past minute. A large value indicates that the I/O workload from this database is exceeding the allocation specified for it in the interdatabase plan.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Wait Time of Small Requests for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Exadata IORM Pluggable Database Metric
This metric category contains the metrics collected for the IORM pluggable databases.
Average I/O Load
This metric reports the average I/O load from this pluggable database for hard disks.
Target Version | Collection Frequency |
---|---|
12c |
Every 15 Minutes |
Average I/O Throughput (MB/Sec)
This metric reports the number of megabytes of I/O per second for this consumer group to hard disks.
Target Version | Collection Frequency |
---|---|
12c |
Every 15 Minutes |
Average Wait Time for Large I/O (ms/req)
This metric reports the average wait time for large I/O requests.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
12c |
Every 15 Minutes |
Not Defined |
Not Defined |
Average IORM Wait time per Large request in milliseconds for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Average Wait Time for Small I/O (ms/req)
This metric reports the average wait time for small I/O requests.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
12c |
Every 15 Minutes |
Not Defined |
Not Defined |
Average IORM Wait time per Small request in milliseconds for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Average Wait Time for I/O (ms/req)
This metric reports the average wait time for I/O requests.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
12c |
Every 15 Minutes |
Not Defined |
Not Defined |
Average IORM Wait time per I/O request in milliseconds for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Cell Name
This metric provides a character string (maximum 400) that specifies the IP addresses of the cell.
Target Version | Collection Frequency |
---|---|
12c |
Every 15 Minutes |
I/O Requests per Second (IO/Sec)
This metric reports the number of IO requests issued by a pluggable database to hard disks per second.
Target Version | Collection Frequency |
---|---|
12c |
Every 15 Minutes |
I/O Requests per Second - Large (IO/Sec)
This metric reports the number of large IO requests issued by a pluggable database to hard disks per second.
Target Version | Collection Frequency |
---|---|
12c |
Every 15 Minutes |
I/O Requests per Second - Small (IO/Sec)
This metric reports the number of small IO requests issued by a pluggable database to hard disks per second.
Target Version | Collection Frequency |
---|---|
12c |
Every 15 Minutes |
I/O Utilization (%)
This metric reports the percentage utilization for I/O requests.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
12c |
Every 15 Minutes |
Not Defined |
Not Defined |
IO Utilization for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Large I/O Utilization (%)
This metric reports the percentage of disk resources utilized by large requests from this Pluggable Database.
Target Version | Collection Frequency |
---|---|
12c |
Every 15 Minutes |
Small I/O Utilization (%)
This metric reports the percentage of disk resources utilized by small requests from this Pluggable Database.
Target Version | Collection Frequency |
---|---|
12c |
Every 15 Minutes |
Wait Time for Large I/O (ms)
This metric specifies the average number of milliseconds that large I/O requests issued by the database have waited to be scheduled by IORM in the past minute. A large value indicates that the I/O workload from this database is exceeding the allocation specified for it in the interdatabase plan
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
12c |
Every 15 Minutes |
Not Defined |
Not Defined |
Wait Time of Large requests for %target%:%object_name%:%cell_name% is %value%, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Wait Time for Small I/O (ms)
This metric specifies the average number of milliseconds that small I/O requests issued by the database have waited to be scheduled by IORM in the past minute.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
12c |
Every 15 Minutes |
Not Defined |
Not Defined |
Wait Time of Small requests for %target%:%object_name%:%cell_name% is %value%, fallen below warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Exadata Smart IO Metric
This metric category contains the Exadata smart IO metrics.
Cell Name
This metric provides a character string (maximum 400) that specifies the IP addresses of the cell.
Target Version | Collection Frequency |
---|---|
11gR2, 12c |
Every 15 Minutes |
Megabytes per second of pass through IOs
This metric provides a number of megabytes per second saved by storage index.
Target Version | Collection Frequency |
---|---|
11gR2, 12c |
Every 15 Minutes |
Megabytes per second read from flash cache
This metric provides a number of megabytes per second read from flash cache by smart IO.
Target Version | Collection Frequency |
---|---|
11gR2, 12c |
Every 15 Minutes |
Megabytes per second read from hard disk
This metric provides a number of megabytes per second read from hard disk by smart IO.
Target Version | Collection Frequency |
---|---|
11gR2, 12c |
Every 15 Minutes |
Filesystem Utilization
This metric category contains the metrics relating to the filesystem utilization.
Cell Name
This metric provides a character string (maximum 400) that specifies the IP addresses of the cell.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 24 Hours |
Filesystem Utilization %
This metric provides the percentage of file system usage on the target.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 24 Hours |
Not Defined |
Not Defined |
File system usage on %target%: %name%:%cell_name% is %value%, which has crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
HCA Port Configuration Monitor
This metric category contains the HCA port configuration monitor metrics.
HCA Node GUID
This metric displays the node GUID.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Is this port disconnected (yes/no)
This metric specifies whether the HCA port is disconnected.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
yes |
Port %PortNumber%(%CA_Display_Name%) on %target% is disconnected from port %ConnectedToSwitchPortNumPrev% on %ConnectedToSwitchNamePrev%. |
Port GUID
This metric provides the port GUID.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Switch GUID on the other end of the link
This metric provides the GUID of the switch to which this port is connected.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Switch Name to which this port is connected
This metric provides the name of the switch to which this port is connected.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
HCA Port Errors
This metric category contains the HCA port error metrics.
Excessive buffer overruns
This metric reports the number of “buffer overruns exceeding the threshold" since the last metric collection.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Port %PortNumber% has %value% excessive buffer overruns, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Incoming VL15 packets dropped due to resource limitation
This metric reports the number of incoming VL 15 packets dropped due to lack of buffers since the last metric collection.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Port %PortNumber% has %value% incoming VL15 packets dropped, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Link integrity errors
This metric displays the number of link integrity errors, that is, errors on the local link.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Port %PortNumber% has %value% link integrity errors, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Link recovers
This metric reports the number of times the link error recovery process was completed successfully since the last metric collection.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Port %PortNumber% has %value% link recovers, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Packets not transmitted due to constraints
This metric reports the number of packets not transmitted due to constrains since the last metric collection.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Port %PortNumber% has %value% packets not transmitted due to constraints, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Received packets discarded due to constraints
This metric reports the number of packets discarded due to constraints since the last metric collection.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Port %PortNumber% has %value% received packets discarded due to constraints, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Received packets marked with the EBP delimiter
This metric reports the number of packets marked with the EBP delimiter received on the port.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Port %PortNumber% has %value% received packets marked with the EBP delimiter, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Received packets with error
This metric reports the number of packets received with errors since the last metric collection.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Port %PortNumber% has %value% received packets containing an error, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Symbol errors
This metric reports the number of symbols errors detected since the last metric collection.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Port %PortNumber% has %value% symbol errors, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
Total errors
This metric reports the sum total of all errors listed in this section.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
Not Defined |
Port %PortNumber% has %value% total errors, crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold. |
HCA Port State
This metric category contains the HCA port state metrics.
Active link width of port based on cable connectivity (e.g., 1X)
This metric displays the active link width of the port based on the cable connectivity.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Is the link degraded? (active speed or width less than enabled)
This metric reports whether or not the link is degraded. If the active speed of a link is less than the enabled speed, then it is considered to be degraded and this column value is set to 1.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
1 |
Port %PortNumber%(%ca_disp_name%) is running in degraded mode. |
Link state (0 = Down, 1 = Active)
This metric reports the link state. The link is down if the physical link state is 0.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Physical link state (0 = Disabled/Polling, 1 = LinkUp)
This metric reports the physical link state. The physical link state is 0 if the port is in polling or disabled state.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
HCA Port State (For Alerts)
The metrics in this category describe the host channel adapters (HCA) port state .
Is port disabled?
This metric indicates whether the HCA port is disabled.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
1 |
Port %PortNumber%(%ca_disp_name%) is disabled. |
Is port in 'polling' state?
This metric indicates whether the HCA port is checking or polling for a peer port.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 15 Minutes |
Not Defined |
1 |
Port %PortNumber%(%ca_disp_name%) is polling for peer port. This could happen when the cable is unplugged from one of the ends or the other end port is disabled. |
Host Interconnect Statistics
This metric category contains the Host Interconnect Statistics metrics.
Cell Name
This metric reports the name of Exadata Storage Server.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Host MB Dropped Per Sec
This metric reports the number of megabytes dropped during transmission to a particular host in the interval.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Host MB Received Per Sec
This metric reports the number of megabytes received from a particular host in the interval.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Host MB Resent Per Sec
This metric reports the number of megabytes retransmitted to a particular host in the interval.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Host MB sent Per Sec
This metric reports the number of megabytes transmitted to a particular host in the interval.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Host RDMA MB Dropped Per Sec
This metric reports the number of megabytes dropped during RDMA transmission to a particular host in the interval.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Response
This metric category contains the metric used to detect whether or not the Management server on the cell is running.This metric is checked at 5 minute intervals. A one in the status column indicates that the cell is up, otherwise the cell is down.
Response Status
This metric is checked at 5 minute intervals. A one in the status column indicates that the cell is up, otherwise the cell is down.
Target Version | Collection Frequency | Default Warning Threshold | Default Critical Threshold | Alert Text |
---|---|---|---|---|
All Versions |
Every 5 Minutes |
Not Defined |
0 |
%target% is down. MS Status is %MSStatus% and Ping Status is %MgmtNetworkPingStatus%. |
Top CPU
This metric category contains the Top CPU metrics.
Activity(%)
This metric reports the percentage of total samples from a specific database.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Begin Sequence
This metric reports the begin sequence number for collection.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Database Name
This metric reports the database unique name ("other" represents unnamed database requests).
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Incarnation
This metric reports the cellsrv incarnation number.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Samples
This metric reports the total samples collected for a specific database in this interval.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
SQLID
This metric reports the SQL unique ID ("0000000000000" represents requests without a SQL ID).
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Oracle Database Exadata Storage Server System
The Oracle Database Exadata Storage Server System target type is a system target that contains all the Oracle Exadata targets that provide storage for one single database.
Agg_Exadata_System_Celldisk_Metric
This metric category provides the metrics collected for a group of Exadata targets that are the storage for one database.
Average Flash Disk IO Load
This metric indicates the average input/output load to the Flash disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average Flash Disk Read IOPS
This metric indicates the average number of bytes read from the Flash disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average Flash Disk Read Throughput
This metric indicates the average number of bytes read from the Flash disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average Flash Disk Write IOPS
This metric indicates the average number of input/output operations written to the Flash disk
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average Flash Disk Write Throughput
This metric indicates the average number of bytes written to the Flash disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average Hard Disk IO Load
This metric indicates the average I/O load to the hard disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average Hard Disk Read IOPS
This metric indicates the average number of read input/output operations from the hard disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average Hard Disk Read Throughput
This metric indicates the average number of bytes read from the hard disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average Hard Disk Write IOPS
This metric indicates the average number of input/output operations written to the hard disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Average Hard Disk Write Throughput
This metric indicates the average number of bytes written to the hard disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Maximum Flash Disk IO Load
This metric indicates the maximum I/O load to the Flash disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Maximum Flash Disk Read IOPS
This metric indicates the maximum number of read input/output operations per second to the Flash disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Maximum Flash Disk Read Throughput
This metric indicates the maximum number of bytes read from the Flash disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Maximum Flash Disk Write IOPS
This metric indicates maximum number of input/output operations written to the Flash disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Maximum Flash Disk Write Throughput
This metric indicates maximum number of bytes written to the Flash disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Maximum Hard Disk IO Load
This metric indicates the maximum I/O load to the hard disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Maximum Hard Disk Read IOPS
This metric indicates the maximum number of input/output operations read from the hard disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Maximum Hard Disk Read Throughput
This metric indicates the maximum number of bytes read from the hard disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Maximum Hard Disk Write IOPS
This metric indicates the maximum number of input/output operations written to the hard disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Maximum Hard Disk Write Throughput
This metric indicates the maximum number of bytes written to the hard disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Minimum Flash Disk IO Load
This metric indicates the minimum I/O load to the Flash disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Minimum Flash Disk Read IOPS
This metric indicates the minimum number of read input/output operations from the Flash disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Minimum Flash Disk Read Throughput
This metric indicates the minimum number of bytes read from the Flash disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Minimum Flash Disk Write IOPS
This metric indicates the minimum number of input/output operations written to the Flash disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Minimum Flash Disk Write Throughput
This metric indicates the minimum number of bytes written to the Flash disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Minimum Hard Disk IO Load
This metric indicates the minimum I/O load to the hard disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Minimum Hard Disk Read IOPS
This metric indicates the minimum number of read input/output operations per second to the hard disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Minimum Hard Disk Read Throughput
This metric indicates the minimum number of bytes read from the hard disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Minimum Hard Disk Write IOPS
This metric indicates the minimum number of input/output operations written to the hard disk.
Target Version | Collection Frequency |
---|---|
All Versions |
Every 15 Minutes |
Oracle Exadata Storage Server Grid
The Oracle Exadata Storage Server Grid target type is a system target that contains all the Oracle Exadata targets from the same Exadata Database Machine system.