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

DB ioReason ioType requestState #Requests
------------------------------------------------------------------------------------------------
EDW Null PredicateCacheGet Queued for Predicate Disk 1
EDW Null PredicateCacheGet Queued for Predicate Read 8
EDW Smart scan Predicate Pushing Predicate Computing 208
EDW Smart scan Predicate Pushing Queued for Predicate Disk 77
EDW Smart scan PredicateFilter Queued for Filtered Backup 48
[oracle@cm01dbm01 source]$
In this output, we see 342 active I/O requests across all of our storage cells as well as a breakdown of I/O
megabytes and active request counts per database, ioReason , ioType , and requestState . You can also run the script
in Listing 13-1 with a -v option to report summarized active request information on per SQL_ID and per object basis:
[oracle@cm01dbm01 source]$ ./lst13-01-activereq.pl -g ~/cell_group -v
... Output omitted for brevity
DB SqlID MB
------------------------------------------------------------------------------------------
EDW brd3nyszkb4v3 339
DB SqlID #Requests
------------------------------------------------------------------------------------------
EDW brd3nyszkb4v3 340
DB Object MB
------------------------------------------------------------------------------------------
EDW 20274 22
EDW 20275 22
... Additional output omitted
DB Object #Requests
------------------------------------------------------------------------------------------
EDW 20274 22
EDW 20275 22
... Additional output omitted
[oracle@cm01dbm01 source]$
How It Works
Active requests are one of three classifications of objects that you can monitor using CellCLI on the Exadata storage
cells, along with metrics and alerts. Active requests provide point-in-time information about actively running I/O
requests as processed by Exadata's cell services software. Active I/O request information can be queried using the
CellCLI list activerequest command and, similar to other storage cell objects, you can limit the output to display
specific activerequest attributes.
In recent versions of Exadata, there are 25 distinct activerequest attributes. You can use the CellCLI describe
command to list the available activerequest attributes, as displayed:
CellCLI> describe activerequest
name
asmDiskGroupNumber