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 are served from memory, it doesn’t account for inefficient queries or unnecessary data access patterns. It’s important to look at other metrics as well.
Q. 82 What does a low “Soft Parse %” in the AWR report suggest?
Ans: It indicates a high proportion of hard parses, which are resource-intensive. This can be caused by not using bind variables, leading to increased CPU usage and potential contention in the shared pool.
Q. 83 How can you improve the “Soft Parse %” ratio?
Ans: Use bind variables to promote cursor sharing, reduce the frequency of SQL statement parsing, and ensure that the shared pool is adequately sized to store execution plans.
Q. 84 What does the “Execute to Parse %” metric indicate?
Ans: It measures the proportion of executions to parses. A high percentage suggests that SQL statements are being reused efficiently, reducing parsing overhead.
Q. 85 How can a low “Latch Hit %” affect database performance?
Ans: It indicates contention for latches, which are lightweight synchronization mechanisms. Low ‘Latch hit %’ can lead to increased wait times and reduced throughput.
You may be interested:
- Performance Testing Interview Question
- Apache JMeter Interview Question
- LoadRunner Interview Question
- Performance Testing Quiz