Monitoring Exadata Cell Servers with Active Requests
Posted by Jim Brull on Tuesday, June 12th, 2018 in Oracle Cloud
no Comment.
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.
Recent Posts
Tags
AWS cloud service providers
Cloud Architecture
cloud cost optimization
Cloud Financials
Cloud Migration
Cloud Optimization
Cloud Roadmap
Cloud Security
Data Security
Engineered Systems
ERP
ERP Systems
Exadata
Google cloud service provider
IaaS
Multi-Cloud
Oracle Architectures
Oracle Autonomous Database Cloud
Oracle Cloud
Oracle Cloud Database
Oracle Cloud ERP
oracle cloud infrastructure
Oracle Cloud managed service provider
Oracle Cloud OCI
Oracle cloud service provider
Oracle Database
Oracle Database in AWS
Oracle DBA
Oracle EBS
Oracle ERP Cloud
Oracle Integration
Oracle Lifetime Support
Oracle Linux
Oracle Managed Service Providers
Oracle Managed Services
Oracle MSP
Oracle OCI
Oracle PaaS
Oracle SaaS
Oracle Security
Oracle Technology
Oracle Training
PaaS
Premier Support
SCM
headquarters
1050 Wilshire Drive,
Suite 170,
Troy, MI 48084
contact us
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
about us
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
