Skip Headers
Oracle® Enterprise Manager System Monitoring Plug-In Metric Reference Manual for Oracle Exadata Storage Server
Release 1.2.4.0.0

E13105-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

1 Oracle Exadata Storage Server Metrics

This chapter provides descriptions for all Oracle Exadata Storage Server metric categories, and the tables list and describe associated metrics for each category.

The chapter is divided into two parts:

The first part describes the metrics that appear in the All Metrics page, and the second part describes the configuration metrics that appear in the View Configuration page.

Metrics Appearing in the All Metrics Page

This section describes the metrics that appear in the All Metrics page. To view the All Metrics page, go to the Oracle Exadata Storage Server Home page, and from the Related Links section, click All Metrics. In each of the individual metric pages, you can use the View Data list to refresh and collect data again from Oracle Exadata Storage Server.

Celldisk Statistics Category

This category provides statistical information about the celldisk.

Table 1-1 Celldisk Statistics Metrics

Metric Description

Celldisk Large Read Latency/Req (msec)

Latency in milliseconds to read large blocks per request on a celldisk

Celldisk Large Write Latency/Req (msec)

Latency in milliseconds to write large blocks per request on a celldisk

Celldisk Read Requests/Sec

Number of requests to read large and small blocks on a celldisk per second

Celldisk Read Throughput/Sec (MB)

Number of megabytes read on a celldisk per second

Celldisk Small Read Latency/Req (msec)

Latency in milliseconds to read small blocks per request on a celldisk

Celldisk Small Write Latency/Req (msec)

Latency in milliseconds to write small blocks per request on a celldisk

Celldisk Write Requests/Sec

Number of requests to write large and small blocks on a celldisk per second

Celldisk Write Throughput/Sec (MB)

Number of megabytes written on a celldisk per second


Cell Offload Efficiency Category

To optimize the performance of queries that perform table and index scans, the database can offload data search and retrieval processing to the storage server. This category provides information about the offload efficiency.

Table 1-2 Cell Offload Efficiency Metrics

Metric Description

Offload Efficiency

Ratio of data accessed by the storage cell to the data that is processed by the database. Larger values mean more offloading to the storage cell.


Cell Statistics Category

This category provides statistical information about the cell.

Table 1-3 Cell Statistics Metrics

Metric Description

CPU Busy (%)

Percentage of time over the previous minute that the system CPUs were not idle (from /proc/stat)

Fan Count

Number of working fans on the cell

NIC IO Recv Req/Sec

Total number of IO packets received by interconnects per second

NIC IO Trans Req/Sec

Total number of IO packets transmitted by interconnects per second

NIC Non-Working Count

Number of non-working interconnects

Run Queue Length

Average number (over the preceding minute) of processes in the Linux run queue marked running or uninterruptible (from /proc/loadavg)

Temperature

Temperature (Celsius) of the server, provided by the BMC


Cell Summary Statistics Category

This category provides cell summary details.

Table 1-4 Cell Summary Statistics Metrics

Metric Description

Avg Celldisk Read Requests

Average number of requests to read large and small blocks per celldisk per second

Avg Celldisk Reads (MB)

Average number of megabytes read on all the celldisks per second

Avg Celldisk Small Read Latency (msec)

Average latency in milliseconds to read large blocks per request on all the celldisk

Avg Celldisk Small Write Latency (msec)

Average latency in milliseconds to write large blocks per request on a celldisk

Avg Celldisk Write_Requests

Average number of requests to write large and small blocks per celldisk per second

Avg Celldisk Writes (MB)

Average number of megabytes written on all the celldisks per second

Max Celldisk Read Requests

Number of requests to read large and small blocks per second from the celldisk with the highest value

Max Celldisk Reads (MB)

Number of megabytes read per second from the celldisk with the highest value

Max Celldisk Small Read Latency (msec)

Latency in milliseconds to read small blocks from the celldisk with the highest value

Max Celldisk Small Write Latency (msec)

Latency in milliseconds to write small blocks from the celldisk with the highest value

Max Celldisk Write Requests

Number of requests to write large and small blocks per second from the celldisk with the highest value

Max Celldisk Writes (MB)

Number of megabytes written per second from the celldisk with the highest value

Total Celldisk Small Write Latency (msec)

Latency in milliseconds to write small blocks on all the celldisks

Total Celldisk Reads (MB)

Number of megabytes read on all the celldisks per second

Total Celldisk Small Read Latency (msec)

Total latency in milliseconds to read small blocks on all the celldisks

Total Celldisk Read Requests

Total number of requests to read large and small blocks on all the celldisks per second

Total Celldisk Write Requests

Total number of requests to write large and small blocks on all the celldisks per second

Total Celldisk Writes (MB)

Total number of megabytes written on all the celldisks per second


Consumer Group Statistics Category

This category provides statistical information about the consumer group.

Table 1-5 Consumer Group Statistics Metrics

Metric Description

CG Large IO Requests/Sec

Number of large IO requests served for a consumer group per second

CG Large IO Wait/Request (msec)

IORM wait time in milliseconds for large IO in a consumer group. A large value indicates that the I/O workload from this consumer group is exceeding the allocation specified for it in the consumer group plan.

CG Small IO Requests/Sec

Number of small IO requests served for a consumer group per second

CG Small IO Wait/Request (msec)

IORM wait time in milliseconds for small IO in a consumer group. A large value indicates that the I/O workload from this consumer group is exceeding the allocation specified for it in the consumer group plan.

Metric Column

Metric column used for internal reports

Plan Type

Plan type used for internal reports


Critical Event Category

This category provides information about the alerts generated from the storage server.

Table 1-6 Critical Event Metrics

Metric Description

Action

Action taken

Alert Begin Time

Time when the alert event was detected

Cell Alert

Identifier for an alert

Examined By

Alert verified by

Msg

Alert message

Notification

Notification sent

Sequence Begin Time

Starting time of the sequence

Severity

Severity of the alert. Values are Critical, Warning, Info.


Database Resource Manager Category

This category provides information about the database resource manager.

Table 1-7 Database Resource Manager Metrics

Metric Description

Category Large IO Requests/Sec

Number of large IO requests served for a category per second

Category Large IO Wait/Request (msec)

IORM wait time in milliseconds for large IO in a category. A large value indicates that the I/O workload from this category is exceeding the allocation specified for it in the category plan.

Category Small IO Requests/Sec

Number of small IO requests served for a category per second

Category Small IO Wait/Request (msec)

IORM wait time in milliseconds for small IO in a category. A large value indicates that the I/O workload from this category is exceeding the allocation specified for it in the category plan.

Metric Column

Metric column used for internal reports

Plan Type

Plan type used for internal reports


Database Statistics Category

This category provides statistical information about the database.

Table 1-8 Database Statistics Metrics

Metric Description

Database Large IO Requests/Sec

Number of large IO requests served for a database per second

Database Large IO Wait/Request (msec)

IORM wait time in milliseconds for large IO in a database. A large value indicates a heavy large I/O workload from this database

Database Small IO Requests/Sec

Number of small IO requests served for a database per second

Database Small IO Wait/Request (msec)

IORM wait time in milliseconds for small IO in a database. A large value indicates a heavy small I/O workload from this database.

Metric Column

Metric column used for internal reports

Plan Type

Plan type used for internal reports.


Filesystem Utilization

This category provides statistical information about the file system.

Table 1-9 Filesystem Utilization Metrics

Metric Description

Filesystem Utilization

Percentage of total space currently used on the file system.


Flashcache Statistics Category

This category provides statistical information about the flash cache.

Table 1-10 Flashcache Statistics Metrics

Metric Description

Flashcache Used (MB)

Number of megabytes used on FlashCache.

IO Errors/sec

Number of IO errors on FlashCache.

Keep Overwrite(MB/sec)

Number of megabytes pushed out of the FlashCache because of space limit for 'keep' objects.

Keep Read Requests Missed/sec

Number of read IO requests for 'keep' objects that did not find all data in FlashCache.

Keep Read Requests Skipped/sec

Number of read IO requests for 'keep' objects with a hint to bypass FlashCache.

Keep Read Requests/sec

Number of read IO requests for 'keep' objects satisfied from FlashCache.

Keep Read Throughput(MB/sec)

Number of megabytes read from FlashCache for 'keep' objects.

Keep Used(MB)

Number of megabytes used for 'keep' objects on FlashCache.

Keep Write Request/sec

Number of IO requests for 'keep' objects that resulted in FlashCache being populated with data.

Keep Write Throughput(MB/sec)

Number of megabytes written to FlashCache for 'keep' objects.

Read Requests Missed/sec

Number of read IO requests that did not find all the data in FlashCache.

Read Requests Skipped/sec

Number of read IO requests with a hint to bypass FlashCache.

Read Requests/sec

Number of read IO requests satisfied from FlashCache.

Read Throughput(MB/sec)

Number of megabytes read from FlashCache.

Reads Missed Throughput(MB/sec)

Number of megabytes read from disks because not all requested data was in FlashCache.

Reads Skipped Throughput(MB/sec)

Number of megabytes read from disks for IO requests with a hint to bypass FlashCache.

Write Requests/sec

Number of IO requests which resulted in FlashCache being populated with data.

Write Throughput(MB/sec)

Number of megabytes written to FlashCache.


Griddisk Statistics Category

This category provides statistical information about the grid disk.

Table 1-11 Griddisk Statistics Metrics

Metric Description

Read Requests Per Sec

Number of requests to read large and small blocks on a griddisk per second

Read Throughput Per Sec (MB)

Number of megabytes read in large and small blocks on a griddisk per second

Write Requests Per Sec

Number of requests to read large and small blocks on a celldisk per second

Write Throughput Per Sec (MB)

Number of megabytes read in large and small blocks on a griddisk per second


Interconnect_SKGXP Statistics Category

This category provides statistical information about Interconnect_SKGXP.

Table 1-12 Interconnect_SKGXP Statistics Metrics

Metric Description

Interconnect_MB_Transmitted

Cumulative number of megabytes transmitted to a particular host

Interconnect_MB_Dropped

Cumulative number of megabytes dropped during transmission to a particular host

Interconnect_MB_Resent

Cumulative number of megabytes retransmitted to a particular host

Interconnect_MB_Received

Cumulative number of megabytes received from a particular host

Interconnect_MB_RDMA_Dropped

Cumulative number of megabytes dropped during RDMA transmission to a particular host

Interconnect_MB_RDMA_Retry_Latency

Cumulative latency of the retry action during RDMA transmission to a particular host


LUN Statistics Category

This category provides statistical information about Logical Unit Number (LUN).

Table 1-13 LUN Statistics Metrics

Metric Description

LUN status

Status of the LUN, which can be normal, warning, or critical.


Physicaldisk Statistics Category

This category provides statistical information about the physical disk.

Table 1-14 Physicaldisk Statistics Metrics

Metric Description

Physicaldisk status

Status of the physical disk, which can be normal, warning, or critical.


Response Category

This category provides response metrics.

Table 1-15 Response Metrics

Metric Description

Response Status

Status of the target


Metrics Appearing in the View Configuration Page

This section describes the metrics that appear in the View Configuration page. To view the View Configuration page, go to the Oracle Exadata Storage Server Home page, and from the Configuration section, click View Configuration.

Cell Celldisk Configuration Category

This category describes the Celldisk configuration metrics.

Table 1-16 Cell Celldisk Configuration Metrics

Metric Description

Name

Unique name of the cell disk.

Cell Name

Name of the cell.

Realm Name

Name of the realm.

Status

Current status of the cell disk. Status can be normal or importRequired

Size (GB)

Total size of the cell disk.

LUN

ID of the LUN on which the cell disk is located.

Error Count

Number of errors that occurred on the cell disk.

Free Space (GB)

Amount of unused space available on the cell disk.

Device Partition

Operating system device name of the partition that is used by the cell disk.


Cell Griddisk Configuration Category

This category describes the Griddisk configuration metrics.

Table 1-17 Cell Griddisk Configuration Metrics

Metric Description

Name

Unique name of the grid disk.

Cell Name

Name of the cell.

Realm Name

Name of the Realm.

Status

Current status of the grid disk. The value is active, inactive, or importRequired.

Size (GB)

Total size of the grid disk.

Creation Time

Time stamp when the grid disk was created.

Cell Disk

Name of the cell disk that contains the grid disk.

Lowest Offset (MB)

Lowest byte offset of the grid disk on the physical disk.

Error Count

Count of hardware errors detected by the cell disk containing this grid disk.

Available To

Indicates the names of the clients that can access this grid disk.


Cell IORM Configuration Category

This category describes the IORM configuration metrics.

Table 1-18 Cell IORM Configuration Metrics

Metric Description

Name

Unique name of the IORM plan. The name value is automatically set to cellname_IORMPLAN.

Cell Name

Name of the cell.

Realm Name

Name of the realm.

Status

Current status of the IORM plan, either active or inactive.

Latency

Latency of the plan is currently not used.

Directive Type

Type of the plan INTER_DATABASE, CATEGORY and CONSUMERGROUP.

Database Name

Name of the database for which the priorities are relevant.

Priority Level 1 to Level 8

The priority of each directive type totals 100%. The various databases will have different priority percentages at different priority levels.

Role

This is currently not used.


Cell LUN Configuration Category

This category describes the LUN configuration metrics.

Table 1-19 Cell LUN Configuration Metrics

Metric Description

Name

Unique name assigned to the LUN. This might be different (or extended from) the LUN ID if the ID is not unique.

Cell Name

Name of the cell.

Realm Name

Name of the realm.

Status

Status of the LUN, which can be normal, warning, or critical.

ID

Identifier assigned by the system.

Cell Disk

Name of the cell disk associated with the LUN. This is empty if the LUN is not associated with a cell disk.

Error Count

Number of errors on this LUN.

Raid Level

Value of the RAID level that is used on the LUN. For example: RAID 0.

Device Name

Operating system device name for the LUN. For example: /dev/cciss/c1d5.

Size (GB)

Raw size of the LUN before being converted to a cell disk.

UID

Unique identifier assigned by the system.

Auto Create

Set to either TRUE or FALSE to indicate whether the LUN was automatically created. Single-disk LUNs are automatically created when disks without LUNs are converted to cell disks. For example, CREATE DISK ALL creates single-disk LUNs for all physical disks without LU.Ns. These single-disk LUNs have this attribute set to TRUE.

Physical Drives

Physical disk names that form the LUN.


Cell Physicaldisk Configuration Category

This category describes the Physicaldisk configuration metrics.

Table 1-20 Cell Physicaldisk Configuration Metrics

Metric Description

Name

Unique name of the physical disk.

Cell Name

Name of the cell.

Realm Name

Name of the realm.

Status

Status of the physical disk, which can be normal, warning, or critical.

ID

Identifier assigned by the system.

Make Model

Model description provided by the system.

LUN/s

List of LUNs converted from this physical disk.

Error Count

Number of errors on this physical disk.

Controller Firmware

Name of the Controller firmware.

Controller HW Version

Name of the controller version.

Physical Interface

Interface type used by the disk. For example, SAS.

Physical Firmware

System-assigned name of the firmware for the disk.

Size (GB)

Size of the disk.

Serial

System-assigned unique ID.

Usage Type

Intended use of the disk. For example, Data Drive.

Port

Port on the controller for this disk.

Insert Time

Time when the disk was inserted.


Oracle Cell Configuration Category

This category describes the Oracle cell configuration metrics.

Table 1-21 Oracle Cell Configuration Metrics

Metric Description

Name

Unique name for the cell.

Status

Status of the cell.

Realm Name

Name assigned by the user as the cell realm.

ID

ID supplied by the hardware vendor.

Make Model

Make and model of the cell hardware supplied by the vendor.

Location

Location of the cell.

BMC Configured

Set to either TRUE or FALSE. If set to true, the hardware is configured to send SNMP traps to Management Server.

BMC Type

Name and version of the BMC.

IP Block

IP block.

Fan Count

Count of working fans and total fans, displayed as working/total.

Power Count

Count of power supplies, displayed as working/total. Not available on HP hardware.

Metric History Days

Number of days that metric history, alert history, and ADR files are retained. The default is 7 days.

SNMP Subscriber

List of hosts that subscribe to the SNMP alert notifications.

SMTP Server

SMTP e-mail server used to send alert notifications.

SMTP Port

SMTP e-mail server port used to send alert notifications.

IP Address 1 to Address 4

IP address 1 to 4 for the cell.

Kernel Version

Version of the host kernel software.

OSS Version

OS version.

Interconnect Count

Number of network interconnection cards.

CPU Count

Number of CPUs on the cell.