Oracle® Enterprise Manager System Monitoring Plug-In Metric Reference Manual for Oracle Exadata Storage Server Release 1.2.4.0.0 Part Number E13105-05 |
|
|
PDF · Mobi · ePub |
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.
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.
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 |
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.
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 |
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 |
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 |
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. |
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 |
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. |
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. |
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 |
This category provides statistical information about Interconnect_SKGXP.
Table 1-12 Interconnect_SKGXP Statistics Metrics
Metric | Description |
---|---|
|
Cumulative number of megabytes transmitted to a particular host |
|
Cumulative number of megabytes dropped during transmission to a particular host |
|
Cumulative number of megabytes retransmitted to a particular host |
|
Cumulative number of megabytes received from a particular host |
|
Cumulative number of megabytes dropped during RDMA transmission to a particular host |
|
Cumulative latency of the retry action during RDMA transmission to a particular host |
This category provides statistical information about Logical Unit Number (LUN).
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.
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. |
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. |
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. |
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. |
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. |
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. |