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:

• Metrics Appearing in the All Metrics Page

• Metrics Appearing in the View Configuration Page

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.