Oracle Database Administration 2022 Certified Professional — Question 33

Which three statements are true about tuning dimensions and details of v$sys_time_model and DB time? (Choose three.)

Answer options

• A. Statspack cannot account for high CPU time when CPU TIME is a Top 10 event in DB time.
• B. When CPU time is high, SQL tuning may improve performance.
• C. Systems in which CPU time is dominant need more tuning that those in which WAIT TIME is dominant.
• D. The proportion of WAIT TIME to CPU TIME always increases with increased system load.
• E. When WAIT TIME is high, instance tuning may improve performance.
• F. Parse Time Elapsed accounts for successful soft and hard parse operations only.
• G. DB Time accounts for all time used by background processes and user sessions.

Correct answer: B, E, G

Explanation

Option B is correct because high CPU time often indicates that SQL tuning can lead to better performance. Option E is also true, as a high WAIT TIME suggests that instance tuning may resolve bottlenecks. Option G is accurate since DB Time represents all time spent by both background and user sessions. The other options either misrepresent the relationship between CPU and WAIT TIME or describe limitations of Statspack inaccurately.