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 actions is recommended if ADDM identifies 'high parse time' as a performance issue? Increase the size of the buffer cache. Implement SQL plan baselines. Increase the shared pool size. Add more CPU resources. None 1 out of 20 2. What is a common cause of 'log file sync' waits in an Oracle database? Slow disk I/O High CPU utilization Insufficient SGA size Network latency 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 upTime is Up!
