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

... Additional activerequest attributes omitted
sqlID
tableSpaceNumber
CellCLI>

Most of the activerequest attributes are self-explanatory in name, but some of the more common
activerequest attributes that we suggest building a monitoring strategy around are outlined below:
The

•

dbName attribute contains the name of your database and is useful when you wish to query
I/O information for specific databases.

• The

ioReason describes the reason for the I/O request and is useful when you wish to query
on Smart Scan operations, block I/O requests, and so forth.

• The

ioType attribute lists the specific I/O operation being performed; the values will vary
based on the ioReason attribute.
The •

requestState attribute displays the current state of the I/O request. Here, large
numbers of queued I/O requests could indicate I/O performance bottlenecks on your
storage cell.

• The

consumerGroupName attribute will display the associated consumer group for the I/O
request and, along with dbName , it provides insight into the different types of sessions
performing I/O requests.

• The

sqlID attribute can be used to measure I/O operations from specific SQL cursors.

• The

objectNumber attribute represents the object number that the I/O request is servicing.

• The

sessionNumber and sessionSerNumber attributes represent the unique session identifier
information from a specific database instance.

13-3. Monitoring Cells with Metrics
Problem
You wish to report current or historical performance, configuration, or alert conditions on the Exadata storage cells
and storage cell components and, specifically, learn how to navigate Exadata's metric “data model” to enable you to
build a robust monitoring strategy.

Solution
In this recipe, you will learn how to do the following:

• Use CellCLI to display Exadata Storage Server metric definitions

• Identify the different metric object types present in the Exadata storage cells

• Query current cell server metrics

• Report on historical storage server metrics

• Identify metric alert conditions

• Recognize how Exadata tracks storage server metrics