Performance Tuning & AWR/ADDM Analysis Quiz Home โบ Oracle DBA โบ Performance Tuning & AWR/ADDM Analysis ๐ Oracle Database Administration – Performance Tuning & AWR/ADDM Analysis 20 questions ยท 15 min timer ยท Explanations included ยท Free 1. Which AWR report section would you analyze to understand the impact of network latency on database performance? Network Statistics SQL Statistics Instance Efficiency Percentages Operating System Statistics None 1 out of 20 2. Which of the following ADDM findings would most likely suggest a need to increase PGA size? High buffer cache hit ratio High CPU usage High redo log space requests High number of sorts to disk None 2 out of 20 Loading questions... 3 out of 20 Loading questions... 4 out of 20 Loading questions... 5 out of 20 Loading questions... 6 out of 20 Loading questions... 7 out of 20 Loading questions... 8 out of 20 Loading questions... 9 out of 20 Loading questions... 10 out of 20 Loading questions... 11 out of 20 Loading questions... 12 out of 20 Loading questions... 13 out of 20 Loading questions... 14 out of 20 Loading questions... 15 out of 20 Loading questions... 16 out of 20 Loading questions... 17 out of 20 Loading questions... 18 out of 20 Loading questions... 19 out of 20 Loading questions... 20 out of 20 Click Submit to see your final score! Previous Start Quiz Next Time's up