Why Study with PlanetCert?
The Latest Questions
Practice questions and exam topics aligned with the current exam objectives.
Detailed Explanations
Go beyond the answer. Master the material with comprehensive learning and professional explanations for every concept.
AI-Powered Insights
Personalized preparation guidance that adapts to your performance and identifies weak spots automatically.
Exam Information
Official specifications published by Oracle
Exam Format
Registration
Validity
1Z0-084 Exam Topics and Domains
1Z0-084 is organized into 16 weighted domains. Expect to work with AWR, DBMS_STATS, Optimizer, AutoTask, and more.
Basic Tuning Methods and Diagnostics
Tuning Methodologies
Apply tuning methodologies effectively
Tuning Lifecycle Phases
Understand and implement tuning across lifecycle phases
Time Model
Describe and utilize the time model for performance analysis
Wait Events
Explain and analyze wait events
V$ Views Diagnostics
Diagnose performance problems using V$ views
Using Statspack
Statspack Installation and Configuration
Install and configure Statspack
Performance Diagnosis with Statspack
Diagnose performance problems using Statspack
Using Log and Trace Files to Monitor Performance
Alert Log Monitoring
Use Alert Log to monitor performance
Trace Files Monitoring
Use Trace files to monitor performance
Using Metrics, Alerts and Baselines
Metric Thresholds and Alerts
Monitor performance using metric thresholds and alerts
AWR Baselines
Use AWR baselines to monitor performance
Using AWR-Based Tools
ADDM Diagnostics
Diagnose performance issues using ADDM
ASH Reports
Diagnose performance issues using ASH reports
Automated Maintenance Tasks
Use Automated Maintenance Tasks to manage performance
Performing Oracle Database Application Monitoring
Real-Time Database Operation Monitoring
Implement Real-Time Database Operation Monitoring
Service-Based Performance Monitoring
Configure and use services to monitor database application performance
Identifying Problem SQL Statements
SQL Statement Processing Phases
Understand the phases for SQL statement processing
Execution Plans
Interpret execution plans
SQL Trace and Optimizer Trace
Use formatted output of SQL Trace or optimizer trace to identify poorly performing SQL statements
Adaptive and Dynamic Execution Plans
Monitor Adaptive/Dynamic Execution plans
Automatic Reoptimization and SQL Plan Directives
Monitor Automatic Reoptimization and SQL Plan Directives
Influencing the Optimizer
Statistics and Optimizer
Explain how statistics influence the optimizer
Optimizer Parameters
Configure parameters to influence the optimizer
Reducing the Cost of SQL Operations
Segment Management
Implement segment shrinking
Row Chaining and Migration
Manage chaining and migration
Index and Table Performance
Configure index and table performance options
Table Compression
Configure table compression
Space Related Issues
Diagnose and tune space related issues
Using Real Application Testing
SQL Performance Analyzer
Use SQL Performance Analyzer to test the impact of database changes
Database Replay
Use Database Replay to check impact of system change on performance
SQL Performance Management
Optimizer Statistics Management
Manage optimizer statistics
Optimizer Statistics Advisor
Use the Optimizer Statistics Advisor
SQL Access and SQL Tuning Advisors
Use SQL Access and SQL Tuning advisors to tune SQL statements
SQL Plan Management
Use SQL Plan Management to tune SQL statements
Tuning the Shared Pool
Shared Pool Performance
Diagnose and resolve performance problems related to the shared pool
Result Cache
Manage and tune the Result Cache
Tuning the Buffer Cache
Buffer Cache Performance
Diagnose and resolve performance problems related to the buffer cache
Database I/O Issues
Diagnose database I/O issues
Big Table Caching
Configure Big Table Caching
Flash Cache
Configure Flash Cache
Tuning the PGA
PGA Performance
Diagnose and resolve performance issues related to PGA
Temporary Tablespace
Diagnose and resolve performance issues related to temporary tablespace
Using Automatic Memory Management
Automatic Shared Memory Management
Configure Automatic Shared Memory Management
Automatic Memory Management
Configure Automatic Memory Management
Using In-Memory Features
In-Memory Column Store
Configure and use In-Memory column store to improve SQL performance
In-Memory Integration
Use In-Memory column store with other database features
How do I earn this certification?
Passing 1Z0-084 earns the Oracle Certified Professional - Performance Management and Tuning certification. It sits in the Database track.
- 1Z0-083 - Oracle Database Administration IIComplete DBA certification path
- 1Z0-085 - Oracle Database SQL Tuning Deep dive into SQL optimization
- OCM - Oracle Certified Master Highest level Oracle certification
- 1Z0-149 - Oracle Database 19c: Program with PL/SQLAdd development skills to performance tuning
- 1Z0-090 - Oracle Database 19c: RAC and Grid Infrastructure Performance tuning in clustered environments
- 1Z0-097 - Oracle Database 19c: Backup and Recovery Complement performance skills with recovery expertise
Practice with Precision
The PlanetCert Simulator mirrors the real exam environment with authentic questions and timed pressure.
How to study for this exam?
The most effective way to prepare for 1Z0-084 is by using the PlanetCert Simulator to practice questions and review detailed explanations.
What's changed on this exam?
- ACTIVE
- Last content update: 2023-06-01
- Announcement date: 2021-03-15
- In-Memory Column Store 19c Enhanced Increased focus on In-Memory configuration and optimization • Release date: 2024-03-01
- Automatic Indexing 19c New questions on automatic vs manual index management • Release date: 2023-12-01
- Real-Time SQL Monitoring Enhanced in 19c Deeper coverage of monitoring capabilities • Release date: 2024-01-15
Who should take this exam?
This exam is typically taken by Database Administrators and Performance Tuning Specialists.
- Oracle Database Administration experience
- Knowledge of Oracle Database architecture
- Familiarity with SQL and PL/SQL
- Understanding of performance tuning concepts
- Hands-on experience with Oracle Database 19c