Databases Reference
In-Depth Information
Chapter 13
Monitoring Exadata Storage Cells
Each Exadata storage cell can be monitored, configured, and managed using the CellCLI command line interface.
With CellCLI, you can monitor active cell server requests, report on a wide range of storage cell metrics, monitor alert
conditions, and monitor each of the storage cell objects including the cell itself, cell disks, grid disks, I/O Resource
Management, as well as Flash Cache, Flash Logging, and your InfiniBand interconnect. Additionally, Exadata provides
the ability to set and modify various metric and alert thresholds.
The Exadata DMA will often monitor storage cells using CellCLI commands as part of an overall performance
and health monitoring strategy. CellCLI monitoring commands generate such a great deal of output that it is often
difficult for the Exadata DMA to summarize the information and make intelligent decisions about its output. Oracle
simplifies this with Exadata plug-ins for Oracle Enterprise Manager, but in situations when Enterprise Manager is
not available, it is still imperative that the Exadata DMA be familiar with CellCLI monitoring techniques in order to
properly support the Exadata Database Machine.
In this chapter, we'll cover some CellCLI and
dcli
monitoring basics, demonstrate how to list current and
historical metrics, and provide real-world examples demonstrating useful Exadata Storage Server monitoring tasks
for a variety of storage cell objects and metrics. With nearly 200 metrics available in recent versions of Exadata, we will
not cover all possible monitoring queries or techniques but, rather, provide a series of recipes that you can expand
upon based on your monitoring needs.
13-1. Monitoring Storage Cell Alerts
Problem
You wish to monitor and report on Exadata Storage Server alert conditions.
Solution
In this recipe, you will learn how to monitor alerts on your Exadata Storage Servers using CellCLI's
list
alerthistory
command, add
cellcli where
conditions to limit the output from the
list alerthistory
command,
flag alerts with the
examinedBy
attribute, and drop alerts from the alert repository.
Displaying Your Alert History
Log in to CellCLI from an Exadata storage cell and run the following command to display your storage cell's
alert history:
CellCLI> list alerthistory
1 2012-10-10T14:41:37-04:00 info "Factory defaults restored for Adapter 0"
2_1 2012-10-17T05:00:33-04:00 info "The disk controller battery is executing a
Search WWH ::
Custom Search