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:…
AWR – Buffer Hit Ratio – Analysis
What is Buffer Hit ratio OR Buffer Hit %? ‘Buffer Hit Ratio’ is measured by the percentage of times the data block is requested by the query and available in memory. It is also called…
AWR – Instance Efficiency Percentages
In AWR, the ‘Instance Efficiency Percentages’ table comes under the ‘Report Summary’ section. Refer to the below figure: The following metrics are available in the ‘Instance Efficiency Percentages’ table of an AWR report: Buffer Nowait…
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 #11
Following are the Performance Engineering Interview Questions Set #11. Q. 51 In the AWR report, where can you find information about PGA memory usage? Ans: The “Memory Statistics” section, specifically under “PGA Aggr Target Stats,”…
- « Previous
- 1
- 2
- 3
- 4
- Next »