OCP Performance Tuning And Diagnostics Practice Question
You need to identify the top SQL statements consuming the most CPU resources in an Oracle 23ai database over the last hour. Which tool provides the most direct analysis of this performance issue?
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
✓
Automatic Workload Repository (AWR) report
AWR reports provide aggregated data over a specific time range, making them ideal for identifying resource consumers.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
SQL Tuning Advisor
Why it's wrong here
This is for tuning a specific statement, not identifying top consumers.
- ✓
Automatic Workload Repository (AWR) report
Why this is correct
AWR provides historical performance data aggregated over time intervals.
- ✗
Active Session History (ASH) report
Why it's wrong here
ASH is better for transient, short-lived performance spikes.
- ✗
SQL Plan Management
Why it's wrong here
This manages plan evolution, not resource identification.
About these practice questions
Courseiva writes every OCP question from scratch — 314 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. 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.