1Z0-084
Oracle Database 19c: Performance Management and Tuning practice test
307 Oracle 1Z0-084 and 1z0-064 practice questions with explanations, in study, timed and flashcard modes. 20 sample questions are free.
Full access
$99
- All 307 questions across 1Z0-084 and 1z0-064, with explanations
- Study, timed and flashcard modes
- Progress saved, resume any time
- Total questions
- 307
- Free samples
- 20
- Versions
- 2
- Updated
- Oct 2026
Exam simulator
Practice 1Z0-084 in the simulator.
Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.
At a glance
1Z0-084, by the numbers.
Official specifications published by Oracle.
- Duration
- 90 min
- Questions
- 55
- Passing score
- 60%
- Exam fee
- $245
- In the bank
- 1Z0-084 (188), 1z0-064 (119)

Exam guide
Everything about 1Z0-084.
1Z0-084 · Oracle · v1.0
What is 1Z0-084?
1Z0-084 tests whether you can find and fix performance problems in Oracle Database 19c. Most candidates are senior database administrators (DBAs) who run busy production systems. A pass makes you an Oracle Certified Professional in Performance Management and Tuning. The exam asks you to diagnose slow systems with the Automatic Workload Repository (AWR), a built-in store of regular performance snapshots. You also tune memory areas such as the shared pool, buffer cache and PGA. For example, you may read an execution plan to see why a query scans a whole table instead of using an index. The practice test works through diagnostics, problem SQL, the optimizer and memory tuning.
What you'll practise
- Diagnose slow databases with AWR, ADDM and ASH reports.
- Find problem SQL statements and read their execution plans and trace files.
- Influence the optimizer with statistics, parameters and the SQL Tuning Advisor.
- Tune the shared pool, buffer cache and PGA, or let automatic memory management do it.
- Test the effect of a change with SQL Performance Analyzer and Database Replay.
- Set metric thresholds, alerts and AWR baselines that warn you before users notice.
Requirements
- No formal prerequisites: anyone can book the exam.
- Recommended: experience as an Oracle Database administrator and a good grasp of its architecture.
- Recommended: working knowledge of SQL and PL/SQL.
- Recommended: hands-on time with Oracle Database 19c.
Who it's for
- Database administrators who look after busy Oracle Database 19c systems.
- Performance tuning specialists and senior DBAs who fix slow queries and workloads.
- Database architects and consultants who plan and review Oracle database performance.
Exam details
Published by Oracle, plus what is in our question bank.
What does 1Z0-084 cover?
The practice test's questions, grouped by exam topic. Open a topic to see what it covers.
14 topics · 31 subtopics · 180 questions
So far, 180 of the 188 questions written for 1Z0-084 are sorted into these topics.
How do I earn this certification?
Passing 1Z0-084 earns the Oracle Certified Professional - Performance Management and Tuning in the Database track.
How to study for this exam?
Use the 1Z0-084 practice test alongside the official material below.
What's changed on this exam?
Status and coverage changes that affect what you should study.
- Current status
- ACTIVE
- Last content update
- Jun 1, 2023
- Announced
- Mar 15, 2021
Three ways to practise
Study mode
Work through the bank at your own pace with the answer and explanation one tap away. Flag questions, add notes, bookmark the hard ones.
Open in the simulatorTimed mode
A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.
Open in the simulatorFlashcards
Question on the front, answer on the back. Good for the last week before the exam.
Open in the simulator