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 of the following ADDM findings would most likely suggest a need to increase PGA size? High buffer cache hit ratio High redo log space requests High number of sorts to disk High CPU usage None 1 out of 20 2. What is the primary purpose of the Automatic Database Diagnostic Monitor (ADDM)? To provide recommendations for performance improvements. To generate AWR reports. To automatically apply performance patches. To manage database backups. 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