To measure CPU utilization in a cloud-based architecture, or, to be specific, in a cluster (e.g., a Kubernetes cluster, Hadoop cluster, or any distributed system), you need to monitor CPU usage across all nodes in…
Following are the Performance Engineering Interview Questions Set #20. Q. 96 How can you correlate database CPU usage with SQL execution in the AWR report? Ans: Examine the “SQL Ordered by CPU Time” section to…
Following are the Performance Engineering Interview Questions Set #19. Q. 91 How does the “Top Timed Events” section help in identifying bottlenecks? Ans: It lists the wait events that consumed the most time during the…
Following are the Performance Engineering Interview Questions Set #18. Q. 86 What is the ‘Load Profile’ section of the AWR and what information does it provide? Ans: The ‘Load Profile’ summarizes key workload characteristics during…
Following are the Performance Engineering Interview Questions Set #17. Q. 81 Is a high buffer cache hit ratio always indicative of good performance? Ans: Not necessarily. While a high hit ratio means most data requests…
Following are the Performance Engineering Interview Questions Set #16. Q. 76 Explain the “latch: cache buffers chains” wait event and its impact. Ans: This wait event indicates contention for cache buffer chain latches, which protect…