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 CPU usage High buffer cache hit ratio High number of sorts to disk High redo log space requests None 1 out of 20 2. Which of the following is the most effective initial step in diagnosing a performance issue using AWR reports? Reviewing the Top SQL by Elapsed Time section. Analyzing the Buffer Cache Hit Ratio. Checking the Load Profile for CPU usage. Examining the Instance Efficiency Percentages. 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!
