9 Oracle Exadata

This chapter provides information about the Oracle Exadata metrics.

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

Allocated (%)

This metric gives an indication of the percentage allocation of the total number of bytes for the 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 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

Total CellDisk Read IOPS

This metric gives an indication of the total number of read input/output operations per second 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

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

Diskgroup Name

This metric reports the name of 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

Size (GB)

This metric reports the diskgroup size in GB 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 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 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 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

Total CellDisk Write Throughput

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

Aggregated Exadata Sparse Diskgroup Capacity

This metric category contains the sparse aggregated capacity metrics for ASM instances and disk groups.

Count

This metric reports the total grid disk number for the specific diskgroup.

Target Version Collection Frequency

All Versions

Every 60 Minutes

Size (GB)

This metric reports the diskgroup size in GB of the aggregated exadata sparse diskgroup.

Target Version Collection Frequency

All Versions

Every 60 Minutes

Virtual Size (GB)

This metric reports the virtual diskgroup size in GB of the aggregated exadata sparse diskgroup.

Target Version Collection Frequency

All Versions

Every 60 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.

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

Action

This metric shows the recommended action to perform for this alert.

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 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%

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

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

Severity

This metric shows the Severity level. Possible values are clear, info, warning, or critical.

Target Version Collection Frequency

11g, 12c

N/A

Cell ILOM Generated Alert

This metric category contains the cell ILOM generated alert metrics. This is shown whenever the Exadata Storage server (cell) ILOM generates alert and the Enterprise Manager subscribes to the cell's SNMP alert.

Chassis Id

This metric shows the Chassis Id of the cell ILOM.

Target Version Collection Frequency

11g, 12c

N/A

Fault Class

This metric shows the fault class of the cell ILOM alert.

Target Version Collection Frequency

11g, 12c

N/A

Fault Message Id

This metric shows the fault message Id of the cell ILOM alert.

Target Version Collection Frequency

11g, 12c

N/A

Fault Status

This metric shows the fault status of the cell ILOM alert.

Target Version Collection Frequency

11g, 12c

N/A

Fault Unique Id (UUID)

This metric shows the fault unique Id (UUID) of the cell ILOM alert.

Target Version Collection Frequency

11g, 12c

N/A

Product Name

This metric shows the product name.

Target Version Collection Frequency

11g, 12c

N/A

CellSrv Status

This metric category contains the cell server status metric.

CellSrv Status

This metric shows the status of the cell server.

Target Version Collection Frequency

11g, 12c

Every 15 Minutes

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.

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.

Cell Name

This is the short name of the Exadata Storage Server without domain suffix.

Target Version Collection Frequency

All Versions

Every 15 Minutes

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 Response Time

This metric reports the average 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

Write Throughput (MBPS)

This metric reports the number of bytes in MB per second written 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.

Object Name

This metric gives an indication of the object, such as hard disk or flash disk name.

Target Version Collection Frequency

All Versions

Every 15 Minutes

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 IORM Database Metric

This metric category contains the IO statistics for the flash cache by database.

Cell Name

This is the short name of the Exadata Storage Server without domain suffix.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Size (MB)

This metric shows the disk size in MB of the Flash Cache IORM Database.

Target Version Collection Frequency

10g, 11g, 12cR1

Every 24 hours

Exadata Flash Cache IORM Pluggable Database Metric

This metric category contains the IO statistics for the flash cache by pluggable database.

Cell Name

This is the short name of the Exadata Storage Server without domain suffix.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Size (MB)

This metric shows the disk size in MB of the Flash Cache IORM Pluggable Database.

Target Version Collection Frequency

13c

Every 15 minutes

Exadata Flash Cache Metric

This metric category contains the performance metrics for the flash cache in a cell.

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

Cell Name

This is the short name of the Exadata Storage Server without domain suffix.

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

Destage Write To Disk Per Second

This metric reports the cumulative number of requests per second to write 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 Population Writes Per Second

The metric reports the number of requests that are population writes into the flash cache due to read miss.

Target Version Collection Frequency

All Versions

Every 15 Minutes

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

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

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

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 Overwrites Per Second

This metric reports the number of megabytes per second pushed out of the flash cache because of space limits for keep objects.

Target Version Collection Frequency

All Versions

Every 15 Minutes

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

Overwrites

This metric reports the cumulative number of requests to overwrite existing data in flash cache.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Overwrites Per Second

This metric reports the cumulative number of requests per second to overwrite existing data in flash cache.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Read Hit Ratio for Random I/O

This metric reports the read hit ratio which is caculated by dividing Read IOPS by the sum of Read IOPS and disk reads per second.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Read IOPS for Random I/O

This metric reports the number of read requests per second from flash cache, for random I/O.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Read IOPS for Scan

This metric reports the number of IO read per second from flash cache, for scan data.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Read Misses (MB)

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

Read Throughput Redirected to Disk for Scan (MBPS)

This metric reports the size of data read per second from disk, for scan data.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Read Throughput for Random I/O (MBPS)

This metric reports the throughput of data read from flash cache for randon I/O.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Read Throughput for Scan (MBPS)

This metric reports the number of megabytes read per second from flash cache, for scan data.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Reads (MB)

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

Reads for Keep (MB)

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

Used (GB)

This metric reports the size of used space on flash cache.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Write IO requests that bypass Flash Cache

This metric reports the cumulative number of writes that bypass flash cache due to the large size of requested objects since the metric was created.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Exadata Flash IORM Consumer Group Metric

This metric category contains the IO statistics of flash by consumer group.

Average I/O Throughput (MB/Sec)

This metric reports the number of megabytes of I/O per second for this consumer group to flash.

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

Average IORM Wait Time for Large I/O (ms/req)

This metric reports the average IORM wait time per request issued by a consumer group for large I/O.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Average IORM Wait Time for Small I/O (ms/req)

This metric reports the average IORM wait time per request issued by a consumer group for small I/O.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Cell Name

This is the short name of the Exadata Storage Server without domain suffix.

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 flash 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 consumer group to flash 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 consumer group to flash per second.

Target Version Collection Frequency

All Versions

Every 15 Minutes

I/O Utilization (%)

This metric reports the percentage of flash resources utilized by requests from this Consumer Group.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Exadata Flash IORM Database Metric

This metric category contains the IO statistics of flash by database.

Average I/O Throughput (MB/Sec)

This metric reports the average number of megabytes of I/O per second for this database to flash.

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 to the flash by a database.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Average IORM Wait Time for Large I/O (ms/req)

This metric reports the average IORM wait time per request issued to the flash by a database for large I/O.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Average IORM Wait Time for Small I/O (ms/req)

This metric reports the average IORM wait time per request issued for the flash by a database for small I/O.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Cell Name

This is the short name of the Exadata Storage Server without domain suffix.

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 the flash 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 the flash 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 the flash per second.

Target Version Collection Frequency

All Versions

Every 15 Minutes

I/O Utilization (%)

This metric reports the percentage of flash resources utilized by requests from this database.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Exadata Flash IORM Pluggable Database Metric

This metric category contains the IO statistics of flash by pluggable database.

Average I/O Throughput (MB/Sec)

This metric reports the average number of megabytes of I/O per second for this pluggable database to flash disks.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Average IORM Wait Time for I/O (ms/req)

This metric reports the average IORM wait time per request issued by a pluggable database to the flash disks.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Average IORM Wait Time for Large I/O (ms/req)

This metric reports the average IORM wait time per request issued by a pluggable database to the flash disks for large I/O.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Average IORM Wait Time for Small I/O (ms/req)

This metric reports the average IORM wait time per request issued by a pluggable database to the flash disks for small I/O.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Cell Name

This is the short name of the Exadata Storage Server without domain suffix.

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 pluggable database to the flash disk 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 pluggable database to the flash disk 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 pluggable database to the flash disk per second.

Target Version Collection Frequency

All Versions

Every 15 Minutes

I/O Utilization (%)

This metric reports the percentage of flash resources utilized by requests from this pluggable database.

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 is the short name of the Exadata Storage Server without domain suffix.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Cumulative Disk Write Errors

This metric reports the cumulative number of write errors encoundered while writing to hard disks.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Cumulative Flash Write Errors

This metric reports the cumulative number of write errors encoundered while writing to flash disks.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Efficiency of Smart Flash Log Over the Past Hour

This metric provides the efficiency of smart flash log over the past hour, that is, the ratio between the number of redo log writes completed by smart flash log in the past hour.

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

Megabytes per second Written to Flash

This metric provides a number of megabytes per second written to flash disk.

Target Version Collection Frequency

All versions

Every 15 Minutes

Megabytes per second Written to Hard Disk

This metric provides a number of megabytes per second written to hard disk.

Target Version Collection Frequency

All versions

Every 15 Minutes

Redo Data Kept

This metric provides the number of bytes of redo data kept over time.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Redo Writes Exceeding Outlier Threshold

This metric provides the number of redo writes that exceed the outlier threshold over time.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Redo Writes Prevented from Exceeding Outlier Threshold

This metric provides the number of redo writes that were prevented from exceeding the outlier threshold over time.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Skipped Large Writes

This metric provides the number of write operations that were skipped for Large I/O.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Skipped Writes Due to Slow Disk

This metric provides the number of write operations that were skipped due to the reason that the hard disk was slow in responding.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Skipped Writes Due to Slow Disk During Last Minute

This metric provides the number of write operations that were skipped due to the reason that the hard disk was slow in responding in the last minute.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Skipped Writes Due to Unavailable Buffer

This metric provides the number of write operations that were skipped due to the unvailability of the buffer.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Writes Serviced

This metric provides the number of write operations that were serviced over the selected time range.

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 is the short name of the Exadata Storage Server without domain suffix.

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

I/O Utilization (%)

This metric reports the percentage of disk resources utilized by requests from this Consumer Group.

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 or to flash disks.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Average latency of reading or writing blocks/request from hard disks

This metric reports the rate which is the average latency of reading or writing blocks per request by a database from or to hard disks.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Average latency of reading or writing large blocks/request from hard disks

This metric reports the rate which is the average latency of reading or writing large blocks per request by a database from or to hard disks.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Average latency of reading or writing small blocks/request from hard disks

This metric reports the rate which is the average latency of reading or writing small blocks per request by a database from or to hard disks.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Cell Name

This is the short name of the Exadata Storage Server without domain suffix.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Cumulative latency of reading or writing blocks from flash disks

This metric reports the cumulative latency of reading or writing blocks by a database from or to flash disks.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Cumulative latency of reading or writing large blocks from hard disks

This metric reports the cumulative latency of reading or writing large blocks by a database from or to hard disks.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Cumulative latency of reading or writing small blocks from hard disks

This metric reports the cumulative latency of reading or writing small blocks by a database from or to 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 is the short name of the Exadata Storage Server without domain suffix.

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 Key Performance Indicators

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

Metric Description Alert Message Clear Message

Exadata Key Performance Indicators

Key performance indicators for the Exadata Storage Server.

-

-

Total Flash Disk IOPS

Aggregated total read and write IOPS of all flash disks on the Exadata Storage Server.

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.

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.

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.

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.

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.

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.

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.

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 flash disk Key Performance Indicators exceeding their critical thresholds for the Exadata Storage Server.

%target% has %value% flash disk Key Performance Indicators exceeding their critical thresholds.

%target% has %value% flash disk Key Performance Indicators exceeding their critical thresholds.

Hard Disk IO Health Exceptions

Number of hard disk Key Performance Indicators exceeding their critical thresholds for the Exadata Storage Server.

%target% has %value% hard disk Key Performance Indicators exceeding their critical thresholds.

%target% has %value% hard disk Key Performance Indicators exceeding their critical thresholds.

Exadata Smart IO Metric

This metric category contains the Exadata smart IO metrics.

Cell Name

This is the short name of the Exadata Storage Server without domain suffix.

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

Megabytes per second saved by storage index

This metric provides a number of megabytes per second saved by storage index.

Target Version Collection Frequency

11gR2, 12c

Every 15 Minutes

Exadata Storage Type

This metric provides information on the available storage types.

Physical Disk Type

This metric column lists available storage types as physical disks on Exadata storage server, for example, HarDisk and FlashDisk.

Target Version Collection Frequency

All versions

Every 24 Hours (1440 Minutes)

Number of Physical Disks

This metric column provides the count of physical disks for each storage type on Exadata Storage Server, for example 12 for HardDisk, and 16 for FlashDisk.

Target Version Collection Frequency

All versions

Every 24 Hours (1440 Minutes)

Number of Cell Disks

This metric column provides count of physical disks that are configured as cell disks for each storage type on Exadata Storage Server, for example 12 for HardDisk, and 16 for FlashDisk.

Target Version Collection Frequency

All versions

Every 24 Hours (1440 Minutes)

Filesystem Utilization

This metric category contains the metrics relating to the filesystem utilization.

Cell Name

This is the short name of the Exadata Storage Server without domain suffix.

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

Switch Port number on the other end of the link

This metric provides the port number 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

The active link speed (Gbps)

The metric reports the speed of the active link.

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 is the short name of the Exadata Storage Server without domain suffix.

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

Host RDMA Retry Latency (msec)

This metric reports the latency of the retry action 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 Activity

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

End Sequence
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

SQL ID

This metric reports the SQL unique ID ("0000000000000" represents requests without a SQL ID).

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

Total Samples

This metric reports the total samples collected in this interval.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Network Port

This metric category contains the metrics used to monitor the performance, traffic statistics and the error statistics of the network ports.

Network Ports InfiniBand Error Statistics

This metric details the error statistics of the InfiniBand ports. The data is collected every 15 minutes.

Metric Summary

Each of the below metric columns have metric data such as Port ID, Average Value, Low Value, High Value, Last Known Value, Current Severity, Alert Triggered, and Last Collection Timestamp.

Metric Column Description

Execution Buffer Overrun Errors

Number of buffer overruns since last collection

Link Downed

Number of failed link errors recovered and link down errors since the last collection

Link Integrity Errors

Number of link integrity errors since last collection

Link Recovers

Number of link error recovers since last collection

Number of packets with the EBP delimiter received on the port since the last collection

Total number of packets with the EBP delimiter received on the port

Received Constraint Errors

Number of received constraint errors since last collection

Received Errors

Number of error packets received on the port since the last collection

Received Switch Relay Errors

Number of received switch relay errors since last collection

Sent Constraint Errors

Number of transmitted constraint errors since last collection

Sent Discards

Number of outbound packets discarded because of down/congested port since last collection

Symbol Errors

Number of minor link errors since the last collection. Usually an 8b/10b error due to a bit error

Total Errors

Total number of errors

Virtual Lanne 15 Packets Dropped

Number of incoming Virtual Lane 15 packets dropped due to resource limitations

Network Ports InfiniBand Performance

This metric provides the performance statistics of the InfiniBand ports. The metric is collected every 15 minutes.

Metric Summary

Metric Column Description Metric Data

Active link width of port based on cable connectivity (e.g., 1X)

The active width of the InfiniBand port

Port ID, Average Value, Last Collected Value, Current Severity, Alert Triggered, Last Collection Timestamp

Cable State

The state of the cable connected to the InfiniBand port

Port ID, Last Collected Value, Current Severity, Alert Triggered, Last Collection Timestamp

Enabled link speed (Gbps)

The enabled speed for the InfiniBand port

Port ID, Last Collected Value, Current Severity, Alert Triggered, Last Collection Timestamp

Enabled link width (e.g., 1X or 4X)

The enabled width of the InfiniBand port

Port ID, Last Collected Value, Current Severity, Alert Triggered, Last Collection Timestamp

Gateway Port Link Mode

The mode of the gateway port, if applicable

Port ID, Last Collected Value, Current Severity, Alert Triggered, Last Collection Timestamp

Is port disabled?

Indicates that the cable is present but the port is disabled

Port ID, Average Value, Low Value, High Value, Last Known Value, Current Severity, Alert Triggered, Last Collection Timestamp

Is port in 'polling' state?

Indicates that the cable is present but the port is polling

Port ID, Average Value, Low Value, High Value, Last Known Value, Current Severity, Alert Triggered, Last Collection Timestamp

Is the link degraded? (active speed or width less than enabled)

Indicates whether the link is degraded on the InfiniBand port

Port ID, Average Value, Low Value, High Value, Last Known Value, Current Severity, Alert Triggered, Last Collection Timestamp

Link state (0 = Down, 1 = Active)

The link state associated with the InfiniBand port

Port ID, Last Collected Value, Current Severity, Alert Triggered, Last Collection Timestamp

Local Port LID

The LID (local identifier) associated with the InfiniBand port

Port ID, Last Collected Value, Current Severity, Alert Triggered, Last Collection Timestamp

Physical link state (0 = Disabled/Polling, 1 = LinkUp )

The physical link state associated with the InfiniBand port

Port ID, Last Collected Value, Current Severity, Alert Triggered, Last Collection Timestamp

Port State

The state of the InfiniBand port

Port ID, Last Collected Value, Current Severity, Alert Triggered, Last Collection Timestamp

Remote Port LID

The LID (local identifier) associated with the remote InfiniBand port

Port ID, Last Collected Value, Current Severity, Alert Triggered, Last Collection Timestamp

Supported link speed (Gbps)

The supported speed for the InfiniBand port

Port ID, Last Collected Value, Current Severity, Alert Triggered, Last Collection Timestamp

Supported link width (e.g., 1X or 4X)

The supported width of the InfiniBand port

Port ID, Last Collected Value, Current Severity, Alert Triggered, Last Collection Timestamp

The active lin kspeed (Gbps)

The active speed of the InfiniBand port

Port ID, Last Collected Value, Current Severity, Alert Triggered, Last Collection Timestamp

Network Ports InfiniBand Traffic Statistics

This metric provides the traffic statistics of the InfiniBand ports. The metric is collected every 15 minutes.

Metric Summary

Each metric column contains the metric data such as Port ID, Average Value, Last Known Value, Current Severity, Alert Triggered, and Last Collection Timestamp.

Metric Column Description

Received Bytes

Total number of incoming octets

Received Multicast Packets

Total number of incoming multicast packets

Received Packets

Total number of incoming packets

Received Unicast Packets

Total number of incoming unicast packets

Sent Bytes

Total number of outgoing octets

Sent Multicast Packets

Total number of outgoing multicast packets

Sent Packets

Total number of outgoing packets

Sent Unicast Packets

Total number of outgoing unicast packets

Network Ports Performance

This metric provides the performance statistics of the network ports. The metric is collected every 15 minutes.

Metric Summary

In the following metrics columns, if the metric provides the status, then the metric data available are Name, Average Value, Last Collected Value, Current Severity, Alert Triggered, and Last Collection Timestamp. If the metric provides numerical values, then additionally, the metric data for Average Value, Low Value, High Value, and Last Known Value are available.

Metric Column Description

Admin State

Administrative state. For example, UP, DOWN, TESTING.

Discarded Packets

Number of discarded packets

Duplex Mode

Actual mode of the port. Full or Half.

Inbound Errors

Number of incoming errors

Inbound Multicast Packets

Number of incoming non-unicast packets

Inbound Octets

Number of incoming octets

Inbound Octets Rate

Total incoming octets rate

Inbound Unicast Packets

Number of incoming unicast packets

Inbound Unknown Protocol

Number of incoming unknown protocol errors

MTU

Actual physical MTU

Operational Status

Operation status of the port. For example, UNKNOWN, UP, DOWN, TESTING, UNCONNECTED.

Outbound Discards

Number of outgoing discards

Outbound Errors

Number of outgoing errors

Outbound Multicast Packets

Number of outbound non-unicast packets

Outbound Octets

Number of outbound octets

Outbound Octets Rate

Total outgoing octets rate

Outbound Unicast Packets

Number of outbound unicast packets

Partition Keys

List of partition keys to which this port belongs

Port is down

Port status became down

Speed

Actual speed of the port

Speed Units

The unit of speed. For example, bytes per second, kilobytes per second, megabytes per second, gigabytes per second.

Total Octets Rate

Total octets rate for incoming and outgoing data

vLAN IDs

List of vLAN IDs to which this port belongs

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

Minimum Hard Disk Write Throughput

This metric indicates the minimum number of bytes written to the hard disk.

Target Version Collection Frequency

All Versions

Every 15 Minutes

Response

This metric category contains the metric used to detect the response of the Oracle Database Exadata Storage Server System.

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.

Target Version Collection Frequency

All Versions

Event-driven

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.

Exadata Key Performance Indicators

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

Metric Description Alert Message Clear Message

Exadata Key Performance Indicators

Key performance indicators for 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.

Response

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

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.

Target Version Collection Frequency

All Versions

Event-driven