9 Oracle Exadata

Action

The recommended action to perform for this alert.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Alert Begin Time

Time stamp when an alert changes its state.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Alert Object

Alert Object Name, such as cell disk or grid disk, for which a metric threshold has caused an alert.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Alert Type

Type of the alert. Values are stateful or stateless.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

ECID

Alert ADR Execution Context Id

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Examined By

Administrator who reviewed the alert.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Incident ID

Alert ADR unique identifier for Enterprise Manager Incident manager.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Msg

A brief explanation of the alert.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Notification

Number indicating progress in notifying subscribers to alert messages.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Problem Key

The Alert ADR Problem Key

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Sequence Begin Time

The time stamp when an alert sequence ID is first created.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Severity

The Severity level. Possible values are clear, info, warning, or critical.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Trace File Name

The Alert ADR Trace File.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

CellSrv Status

This is the status of the cell server

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Average CellDisk Read IOPS

This gives an indication of the average number of read input/output operations per second

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Average CellDisk Read Throughput

This gives an indication of the average number of bytes read from the cell disk

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Average CellDisk Write IOPS

This gives an indication of the average number of write input/output operations to the cell disk

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Average CellDisk Write Throughput

This gives an indication for the average number of bytes written to the cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Total CellDisk Read IOPS

This gives an indication of the total number of read input/output operations per second to the cell disk

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Total CellDisk Read Throughput

This gives an indication for the total number of bytes read from the cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Total CellDisk Write IOPS

This gives an indication of the total number of write input/output operations per second to the cell disk

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Total CellDisk Write Throughput

This gives an indication for the total number of bytes written to the cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Average CellDisk IO Load

This gives an indication of the average input/output load to the cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Average CellDisk Read Response Time

This gives an indication of the average read response time to the cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Average CellDisk Write Response Time

This gives an indication of the average write response time to the cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Maximum CellDisk IO Load

This gives an indication of the maximum input/output load to the cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Total CellDisk IO Load

This 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.

Since 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.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Object Name

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

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

IO Load Imbalance

This gives an indication of the percentage of maximum average I/O load from the cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Usage (%)

This gives an indication of the percentage utilization total number of bytes written to the hard disk, flash disk, flash cache, and grid disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Disk Type

This column indicates the metrics are for hard disk, flash disk, flash cache, and grid disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Disk Size (GB)

This gives an indication of the size of the status in GB.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

ASM Instance

This is the ASM instance name for the aggregated exadata diskgroup

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Diskgroup Name

This is the name of the aggregated exadata diskgroup

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Size (GB)

This is the diskgroup size in GB of the aggregated exadata diskgroup.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Count

This is the total grid disk number for the specific diskgroup.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Average CellDisk Read IOPS

This gives an indication of the average number of read input/output operations from the hard disks or flash disks in a cell.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Average CellDisk Read Throughput

This gives an indication of the average number of bytes read from the hard disks or flash disks in a cell.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Average CellDisk Write IOPS

This gives an indication of the average number of input/output operations written to the hard disks or flash disks in a cell.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Average CellDisk Write Throughput

This gives an indication of the average number of bytes written to the hard disks or flash disks in a cell.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

CellDisk Type

This indicates the type of Cell disk, either hard disk or flash disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Total CellDisk Read IOPS

This gives an indication of the total number of bytes read from the hard disks or flash disks in a cell.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Total CellDisk Read Throughput

This gives an indication of the total number of bytes read from the hard disks or flash disks in a cell.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Total CellDisk Write IOPS

This gives an indication of the total number of bytes written to the hard disks or flash disks in a cell.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Total CellDisk Write Throughput

This gives an indication of the total number of bytes written to the hard disks or flash disks in a cell.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Average CellDisk IO Load

This gives an indication of the average input/output load to the cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Average CellDisk Read Response Time

This gives an indication of the average read response time to the cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Average CellDisk Small Read Response Time

This gives an indication of the average response time when reading small blocks from the cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Average CellDisk Small Write Response Time

This gives an indication of the average response time when writing small blocks to the cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Average CellDisk Write Response Time

This gives an indication of the average response time when writing to the cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Total CellDisk IO Load

This 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.

Since 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.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

CellDisk Type

This column indicates the celldisk type, either hard disk or flash disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Large Read Bytes

This column indicates the number of MB read in large blocks from a cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Large Read Latency

This column indicates the latency in reading large blocks from a cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Large Read Requests

This column indicates the number of requests to read large blocks from a cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Large Write Bytes

This column indicates the number of MB written in large blocks to a cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Large Write Latency

This column indicates the latency in writing large blocks to the cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Large Write Requests

This column indicates the number of requests to write large blocks to a cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Object Name

This column indicates the cell disk name.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Read IOPS

This column indicates the number of read input/outputs per second to a cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Read Latency

This column indicates the read latency from a cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Read Throughput (MBPS)

This column indicates the number of bytes in MB per second read from a cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Small Read Bytes

This column indicates the number of MB read in small blocks from a cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Small Read Latency

This column indicates the latency in reading small blocks from a cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Small Read Requests

This column indicates the number of requests to read small blocks from a cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Small Write Bytes

This column indicates the number of MB written in small blocks to a cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Small Write Latency

This column indicates the latency in writing small blocks to a cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Small Write Requests

This column indicates the number of requests to write small blocks to a cell disk..

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Write IOPS

This column indicates number of write input/outputs operations per second to a cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Write Latency

This column indicates the latency in writing to a cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Write Throughput (MBPS)

This column indicates the number of bytes in MB per second written to a cell disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Cell Name

This column indicates the exadata cell name.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

CPU Utilization

This column provides information on the CPU utilization.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Memory Utilization

This column provides information on the memory utilization.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Network Received

This column indicates the total number of I/O packets received by interconnections per second.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Network Sent

This column indicates the total number of I/O packets transmitted by interconnections per second.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

ASM Instance

This is the exadata ASM Instance name

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Disk Group

This is the exadata diskgroup name

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Freespace (GB)

This is the amount of freespace available in GB in the exadata diskgroup

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Disk Name

This column indicates the name of the objects, they can be cell disk names, flash disk name, flash cache names, and grid disk names.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Disk Type

This column indicates the metrics are for cell disk, flash disk, flash cache, and grid disk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Disk Size (GB)

This column indicates the size of the objects in GB.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Disk Status

This column indicates the status of the objects for cell disk, flash disk, flashcache and griddisk.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Average Throttle Time per Disk I/O by Consumer Group

This is the average number of milliseconds that both small and large I/O requests issued by the consumer group have waited to be scheduled by IORM in the past minute.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Cell Name

This is the name of Exadata Storage Server.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Disk I/O Requests per Second by Consumer Group

This is the rate of both small and large I/O requests issued by a consumer group per second over the past minute.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

- Disk I/O Utilization by Consumer Group

This is the percentage of disk resources utilized by both small and large requests from this consumer group.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

IO Large Request per Second

This is the rate of large I/O requests issued by a consumer group per second over the past minute. A large value indicates a heavy I/O workload from this consumer group in the past minute.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

IO Small Request per Second

This is the rate of small I/O requests issued by a consumer group per second over the past minute. A large value indicates a heavy I/O workload from this consumer group in the past minute.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

IO Wait of Large Request

This is the average number of milliseconds that large I/O requests issued by the consumer group have waited to be scheduled by IORM in the past minute. A large value indicates that the I/O workload from this consumer group is exceeding the allocation specified for it in the database resource plan.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

IO Wait of Small Request

This is the average number of milliseconds that small I/O requests issued by the consumer group have waited to be scheduled by IORM in the past minute. A large value indicates that the I/O workload from this consumer group is exceeding the allocation specified for it in the database resource plan.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Number of Megabytes of Disk I/O per Second by Consumer Group

This is the number of megabytes of I/O per second for this consumer group to hard disks.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Percentage of disk resources utilized by Large requests

This is the percentage of disk resources utilized by large requests from this consumer group.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Percentage of disk resources utilized by Small requests

This is the percentage of disk resources utilized by small requests from this consumer group.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Object Name

This column indicates the name of the objects, for example, cell disk names or flash cache names.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Object Type

This column indicates the metrics are for cell disk, flash cache, IORM database etc.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Cell Name

A character string (maximum 400) that specifies the IP addresses of the cell

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Default Hits

This is the number of read requests that were a cache hit on exadata flash cache.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Default Hits (%)

This is the percentage number of read requests that were a cache hit on exadata flash cache.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Default Misses

This is the umber of default misses

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Default Misses (%)

This is the percentage of default misses

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Default Read IOPS

This is the number of default input/output operations per second.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Default Read Throughput (MBPS)

This is the default number of bytes in MB per second read from a cell disk

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Default Used (GB)

This is the default number of bytes used in GB.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Flashcache All I/O Requests

This is the number of requests for all flashcache input/outputs operations

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Flashcache Megabytes Reads

This is the number f bytes read in MB

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Flashcache Megabytes Reads for Keep

This is the number of bytes read in MB

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Flashcache I/O Requests for Keep

This is the number of requests for flashcache input/output operations.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Flashcache I/O Reqs Read Misses

This is the number of flash cache input/output request read misses

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Flashcache Megabytes Read Misses

This is the number of read misses in MB

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Keep Pool Read IOPS

This is the number of input/output operations read per second.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Keep Pool Read Throughput (MBPS)

This is the number of bytes read in MB per second

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Keep Pool Used (GB)

The size of the keep pool in GB

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Object Name

This is the object name.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Default Read IOPS

This is the number of read input/output operations per second.

Default Read Throughput (MBPS)

This is the read throughput in megabytes per seconds.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Cell Name

A character string (maximum 400) that specifies the IP addresses of the cell

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

IO Utilization

This is the percentage utilization for I/O requests

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Large IO Utilization

This is the percentage utilization for large I/O requests

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Small IO Utilization

This is the percentage utilization for small I/O requests

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Number of Large Requests

This metric specifies the number of large I/O requests issued by the database. A large value indicates a heavy I/O workload from this category

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Number of Small Requests

This metric specifies the number of large I/O requests issued by the database.A large value indicates a heavy I/O workload from this category

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Object Name

This is the object name

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Wait Time of Large Requests

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.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Wait Time of Small Requests

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.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

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.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

IORM Plan Status

This is the status of the interdatabase plan, either active or inactive.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Database Name

This is the database unique name ("other" represents unnamed database requests).

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

SQLID

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

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Activity(%)

This is the percentage of total samples from a specific database.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Begin Sequence

This is the begin sequence number for collection.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

End Sequence

This is the end sequence number for collection.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Incarnation

This is the cellsrv incarnation number.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Samples

This is the total samples collected for a specific database in this interval.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Total Samples

This is the total samples collected in this interval.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Cell Name

This is the name of Exadata Storage Server.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Host MB Dropped Per Sec

This is the number of megabytes dropped during transmission to a particular host in the interval.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Host MB Received Per Sec

This is the number of megabytes received from a particular host in the interval.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Host MB Resent Per Sec

This is the number of megabytes retransmitted to a particular host in the interval.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Host MB sent Per Sec

This is the number of megabytes transmitted to a particular host in the interval.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Host RDMA MB Dropped Per Sec

This is the number of megabytes dropped during RDMA transmission to a particular host in the interval.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.

Host RDMA Retry Latency (msec)

This is the latency of the retry action during RDMA transmission to a particular host in the interval.

Metric Summary for Database Control

The following table shows how often the metric's value is collected.