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 #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…
Following are the Performance Engineering Interview Questions Set #15. Q. 71 How can you reduce the ‘Buffer Busy Waits’ identified in the AWR report? Ans: It can be reduced by: Q. 72 What are wait…
Following are the Performance Engineering Interview Questions Set #14. Q. 66 What is the difference between ‘db file sequential read’ and ‘db file scattered read’ wait events? Ans: The ‘db file sequential read’ indicates single-block…
In AWR, the ‘Instance CPU’ table comes under the ‘Report Summary’ section. Refer to the below figure: To analyse the ‘Instance CPU’ section, you must Look at the Host CPU and Instance CPU sections. The…