Monitoring Exadata Cell Servers with Active Requests

An active request represents a “client” or application-centric view of I/O requests being processed by the cell. Similar to previous sections, the graphic below shows the detail associated with Active Request monitoring.
You can use the ioType above to monitor which type of IO is being done, and if run with “detail” it’ll show results for all the information in the light-blue color in the graphic above. The output is relatively self-explanatory – I’ll generate some load using SwingBench to show some actual results.
SQL>
1 declare
2 x number;
3 begin
4 for i in 1..1000 loop
5 select /*+ full (X) parallel (X,8) */
count(*)
6 into x
7 from orders X;
8 end loop;
9* end;
SQL> /

 

CellCLI> list activerequest detail;
name: 0
asmDiskGroupNumber: 0
asmFileIncarnation: 0
asmFileNumber: 0
consumerGroupID: 12422
consumerGroupName: OTHER_GROUPS
dbID: 2080757153
dbName: DBM
dbRequestID: 0
fileType:
id: 0
instanceNumber: 2
ioBytes: 1048576
ioBytesSofar: 0
ioGridDisk: /box/predicate330
ioOffset: 0
ioReason: "Smart scan"
ioType: "Predicate Pushing"
objectNumber: 19747
parentID: 0
requestState: "Predicate Computing"
sessionID: 1043
sessionSerNumber: 8955
sqlID: 9gxpqw6ykppfd
tableSpaceNumber: 7

name: 0
asmDiskGroupNumber: 0
asmFileIncarnation: 0
asmFileNumber: 0
consumerGroupID: 12422
consumerGroupName: OTHER_GROUPS
dbID: 2080757153
dbName: DBM
dbRequestID: 0
fileType:
id: 0
instanceNumber: 2
ioBytes: 1048576
ioBytesSofar: 0
ioGridDisk: /box/predicate331
ioOffset: 0
ioReason: "Smart scan"
ioType: "Predicate Pushing"
objectNumber: 19752
parentID: 0
requestState: "Predicate Computing"
sessionID: 1173
sessionSerNumber: 9099
sqlID: 9gxpqw6ykppfd
tableSpaceNumber: 7

name: 0
asmDiskGroupNumber: 0
asmFileIncarnation: 0
asmFileNumber: 0
consumerGroupID: 12422
consumerGroupName: OTHER_GROUPS
dbID: 2080757153
dbName: DBM
dbRequestID: 0
fileType:
id: 0
instanceNumber: 2
ioBytes: 1048576
ioBytesSofar: 0
ioGridDisk: DATA_CM01_CD_01_cm01cel01
ioOffset: 11148080
ioReason: "Smart scan"
ioType: PredicateFilter
objectNumber: 19756
parentID: 0
requestState: "Queued for Filtered Backup"
sessionID: 848
sessionSerNumber: 11
sqlID: 9gxpqw6ykppfd
tableSpaceNumber: 7

name: 0
asmDiskGroupNumber: 0
asmFileIncarnation: 0
asmFileNumber: 0
consumerGroupID: 12422
consumerGroupName: OTHER_GROUPS
dbID: 2080757153
dbName: DBM
dbRequestID: 0
fileType:
id: 0
instanceNumber: 2
ioBytes: 1048576
ioBytesSofar: 0
ioGridDisk: /box/predicate333
ioOffset: 0
ioReason: "Smart scan"
ioType: "Predicate Pushing"
objectNumber: 19756
parentID: 0
requestState: "Predicate Computing"
sessionID: 848
sessionSerNumber: 11
sqlID: 9gxpqw6ykppfd
tableSpaceNumber: 7

name: 0
asmDiskGroupNumber: 0
asmFileIncarnation: 0
asmFileNumber: 0
consumerGroupID: 12422
consumerGroupName: OTHER_GROUPS
dbID: 2080757153
dbName: DBM
dbRequestID: 0
fileType:
id: 0
instanceNumber: 2
ioBytes: 1048576
ioBytesSofar: 0
ioGridDisk: DATA_CM01_CD_04_cm01cel01
ioOffset: 17072864
ioReason: "Smart scan"
ioType: PredicateFilter
objectNumber: 19743
parentID: 0
requestState: "Queued for Filtered Backup"
sessionID: 1108
sessionSerNumber: 1295
sqlID: 9gxpqw6ykppfd
tableSpaceNumber: 7

name: 0
asmDiskGroupNumber: 0
asmFileIncarnation: 0
asmFileNumber: 0
consumerGroupID: 12422
consumerGroupName: OTHER_GROUPS
dbID: 2080757153
dbName: DBM
dbRequestID: 0
fileType:
id: 0
instanceNumber: 2
ioBytes: 1048576
ioBytesSofar: 0
ioGridDisk: /box/predicate334
ioOffset: 0
ioReason: "Smart scan"
ioType: "Predicate Pushing"
objectNumber: 19743
parentID: 0
requestState: "Predicate Computing"
sessionID: 1108
sessionSerNumber: 1295
sqlID: 9gxpqw6ykppfd
tableSpaceNumber: 7

name: 0
asmDiskGroupNumber: 0
asmFileIncarnation: 0
asmFileNumber: 0
consumerGroupID: 12422
consumerGroupName: OTHER_GROUPS
dbID: 2080757153
dbName: DBM
dbRequestID: 0
fileType:
id: 0
instanceNumber: 2
ioBytes: 1048576
ioBytesSofar: 0
ioGridDisk: /box/predicate335
ioOffset: 0
ioReason: "Smart scan"
ioType: "Predicate Pushing"
objectNumber: 19749
parentID: 0
requestState: "Predicate Computing"
sessionID: 1238
sessionSerNumber: 41
sqlID: 9gxpqw6ykppfd
tableSpaceNumber: 7

name: 0
asmDiskGroupNumber: 0
asmFileIncarnation: 0
asmFileNumber: 0
consumerGroupID: 12422
consumerGroupName: OTHER_GROUPS
dbID: 2080757153
dbName: DBM
dbRequestID: 0
fileType:
id: 0
instanceNumber: 2
ioBytes: 1048576
ioBytesSofar: 0
ioGridDisk: /box/predicate337
ioOffset: 0
ioReason: "Smart scan"
ioType: "Predicate Pushing"
objectNumber: 19745
parentID: 0
requestState: "Predicate Computing"
sessionID: 914
sessionSerNumber: 17193
sqlID: 9gxpqw6ykppfd
tableSpaceNumber: 7

name: 0
asmDiskGroupNumber: 0
asmFileIncarnation: 0
asmFileNumber: 0
consumerGroupID: 12422
consumerGroupName: OTHER_GROUPS
dbID: 2080757153
dbName: DBM
dbRequestID: 0
fileType:
id: 0
instanceNumber: 2
ioBytes: 1048576
ioBytesSofar: 0
ioGridDisk: /box/predicate338
ioOffset: 0
ioReason: "Smart scan"
ioType: "Predicate Pushing"
objectNumber: 19757
parentID: 0
requestState: "Predicate Computing"
sessionID: 783
sessionSerNumber: 473
sqlID: 9gxpqw6ykppfd
tableSpaceNumber: 7

CellCLI>

Summary

Monitoring Exadata by “active requests” provides insight into current Exadata cell server processing. For DBAs familiar with monitoring database wait events with V$SESSION_WAIT, monitoring Exadata with active requests is a decent analogy.