AWR – Host CPU
In AWR, the ‘Host CPU’ table comes under the ‘Report Summary’ section. Refer to the below figure: The following metrics are available in the ‘Host CPU’ table of an AWR report: CPUs The number of…
AWR – Wait Classes by Total Wait Time
In AWR, the ‘Wait Classes by Total Wait Time’ table comes under the ‘Report Summary’ section. Refer to the below figure: To analyse this section, firstly check for the ‘Wait Class’ column. If User I/O,…
AWR – Top 10 Foreground Events
In AWR, the ‘Top 10 Foreground Events’ table comes under the ‘Report Summary’ section. Refer to the below figure: The following metrics are available in the ‘Top 10 Foreground Events’ table of an AWR report:…
Performance Engineering Interview Questions #13
Following are the Performance Engineering Interview Questions Set #13. Q. 61 How can lock contention be identified in an AWR report? Ans: High wait events like “enq: TX- row lock contention” or “enq: TM- contention”…
Performance Engineering Interview Questions #12
Following are the Performance Engineering Interview Questions Set #12. Q. 56 What role does the buffer cache play in database performance? Ans: The buffer cache stores copies of data blocks read from the disk. A…
Performance Engineering Interview Questions #10
Following are the Performance Engineering Interview Questions Set #10. Q. 46 What is a Large Pool in Oracle DB? Ans: The large pool is an optional memory area intended for memory allocations that are larger than is…
- « Previous
- 1
- 2
- 3
- Next »