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

[celladmin@cm01cel01 ~]$ cellcli
CellCLI: Release 11.2.3.1.1 - Production on Tue Oct 23 00:03:05 EDT 2012
Copyright (c) 2007, 2011, Oracle. All rights reserved.
Cell Efficiency Ratio: 197
CellCLI>

Next, run the list activequest command:

CellCLI> list activerequest
0 OTHER_GROUPS EDW "Smart scan" "Predicate Pushing" "Queued for Predicate Disk"
0 OTHER_GROUPS EDW "Smart scan" PredicateFilter "Queued for Filtered Backup"
0 OTHER_GROUPS EDW "Smart scan" "Predicate Pushing" "Predicate Computing"
... Additional list activequest detail omitted

Without supplying an attributes clause or providing additional selection criteria, the list activerequest
command will display the request name, the consumer group name, database name, the I/O reason and I/O type,
and the current request state. In the previous output, you can see that the database EDW is executing a number of
Smart Scan operations with Predicate Pushing and Predicate Filtering , with a request state represented in the
rightmost column of the output.
Some of the more common types of list activerequests queries involve reporting I/O operations that are
performing Smart Scans, listing I/O operations that are conducting Smart Scan predicate filtering, reporting on I/O
operations for a specific Oracle session or SQL_ID , listing active I/O operations issued from a specific database, and
others. To list your current Smart Scan I/O requests conducting predicate filtering operations, issue the following
command from CellCLI:

CellCLI> list activerequest where ioReason="Smart scan" attributes dbName,ioReason,ioType,requestState
EDW "Smart scan" "Predicate Pushing" "Predicate Computing"
EDW "Smart scan" "Predicate Pushing" "Queued for Predicate Disk"
EDW "Smart scan" PredicateFilter "Queued for Filtered Backup"
EDW "Smart scan" "Predicate Pushing" "Predicate Computing"
EDW "Smart scan" PredicateFilter "Queued for Filtered Backup"
EDW "Smart scan" PredicateFilter "Queued for Filtered Backup"
EDW "Smart scan" PredicateFilter "Queued for Filtered Backup"
... Additional output omitted

On busy Exadata environments, listing active I/O requests with list activerequest can display a great deal of
information. In order to summarize your active I/O requests information, execute the Perl script in Listing 13-1 from a
node in your Exadata Database Machine.

■ the script in listing 13-1 assumes that you have a cell_group file created containing a list of each exadata
storage cell and that you have established SSh trust. please see recipe 7-2 to learn how to configure this.

Note

Listing 13-1. lst13-01-activereq.pl

#!/usr/bin/perl
# Name: lst13-01-activereq.pl
# Usage: ./lst13-01-ar.pl [-g|-c] [cell group file|list of cells] [-s|-v]
use Getopt::Std;
use Text::ParseWords;