Performance Engineering Interview Questions #20

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 identify SQL statements consuming the most CPU. Cross-reference with overall CPU usage statistics to assess their impact on database performance.

Q. 97 What role does “ASH Data” play in enhancing AWR analysis?

Ans: Active Session History (ASH) samples session activity, providing granular insights into session behaviour over time. ASH data can help pinpoint transient issues not apparent in aggregated AWR statistics.

Q. 98 How can you use the “Segment Statistics” section to identify problematic database objects?

Ans: It lists segments with the highest activity in terms of logical reads, physical reads, or row lock waits, allowing you to focus tuning efforts on specific tables or indexes.

Q. 99 What is the importance of monitoring “Undo Statistics” in the AWR report?

Ans: High undo generation can indicate excessive DML operations or long-running transactions, which may impact performance and require adjustments to undo tablespace sizing.

Q. 100 How can you assess whether parallel execution is effectively utilized in the database?

Ans: Review the “Parallel Execution” statistics in the AWR report to see metrics like the number of parallel operations and the efficiency of parallel workers, helping determine if parallelism is benefiting the performance.