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.
1050 Wilshire Drive,
Suite 170,
Troy, MI 48084
Phone: (248) 465-9533
Toll free: 1-877-868-1753
Email: [email protected]
© Centroid, Inc. All rights reserved. Contact Privacy Policy Terms of Use CCPA Policy
Centroid is a cloud services and technology company that provides Oracle enterprise workload consulting and managed services across Oracle, Azure, Amazon, Google, and private cloud. From applications to technology to infrastructure, Centroid’s depth of Oracle expertise and breadth of cloud capabilities helps clients modernize, transform, and grow their business to the next level.
© Centroid, Inc. All rights reserved. Contact Privacy Policy Terms of Use CCPA Policy