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. In an AWR report, which metric would you examine to determine the impact of database locks on performance? Enqueue Waits Buffer Busy Waits Latch Free Waits Redo Log Waits 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!
