Monitoring Exadata Storage Cells - Oracle Exadata Recipes: A Problem-Solution Approach - page 374

You will begin by learning about the metricdefinition object and build upon your understanding of the metric
object attributes to construct CellCLI queries against current and historical storage server metrics. The examples
in this recipe will focus on specific storage server metrics and outline commonly used CellCLI list commands to
demonstrate the relationships and meanings between the metrics objects, limit list output using where conditions,
and customize column output using the attributes clause.
Listing Storage Server Metrics
Launch cellcli from any Exadata storage cell and run the following describe metricdefinition command:
CellCLI> describe metricdefinition
name
description
metricType
objectType
persistencePolicy
unit
CellCLI>
Next, run the list metricdefinition command to display the available storage server metrics:
CellCLI> list metricdefinition
CD_IO_BY_R_LG
CD_IO_BY_R_LG_SEC
CD_IO_BY_R_SM
... Additional metrics omitted
With recent versions of Exadata, you will have nearly 200 metrics available to you. Each of these metrics tracks
information for different components in your Exadata Storage Servers. The previous output shows a single attribute,
or column—this corresponds to the name attribute in the metricdefinition object. You can list information about a
specific metric using the list command with the metric name supplied, as listed:
CellCLI> list metricdefinition CL_CPUT
CL_CPUT
CellCLI>
Above, we're displaying a specific storage server metric, CL_CPUT . What does this metric represent? Add the
detail clause at the end of your CellCLI list command to display all of the metric's attributes:
CellCLI> list metricdefinition CL_CPUT detail
name: CL_CPUT
description: "Percentage of time over the previous minute that the system CPUs were
not idle."
metricType: Instantaneous
objectType: CELL
unit: %
CellCLI>