OCP Performance Tuning And Diagnostics Practice Question
An administrator needs to identify the top wait events causing performance degradation in the database over the last hour. Which tool provides the most granular, session-level view of these wait events?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Active Session History (ASH)
ASH provides real-time, session-level performance data, making it the ideal tool for analyzing short-term, granular performance spikes.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Active Session History (ASH)
Why this is correct
ASH captures active session state every second, providing the necessary granularity for real-time analysis.
- ✗
SQL Tuning Advisor
Why it's wrong here
SQL Tuning Advisor is used to improve the performance of specific SQL statements, not for general wait event analysis.
- ✗
Automatic Database Diagnostic Monitor (ADDM)
Why it's wrong here
ADDM analyzes AWR data over longer periods and provides recommendations, not granular, real-time session snapshots.
- ✗
Automatic Workload Repository (AWR)
Why it's wrong here
AWR snapshots are typically taken every hour and aggregate data, which is too coarse for immediate session-level troubleshooting.
About these practice questions
One of 312 original OCP practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed August 2026 · checked against the official Oracle exam blueprint
This OCP practice question is part of Courseiva's free Oracle certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the OCP exam.