Oracle credentialCER0446Active

Oracle Certified Professional, Oracle Database 19c: Performance Management and Tuning

Exam code: 1Z0-084Oracle Database 19cOracle Database
Official provider page
Oracle
Credential
Certification
Exam duration
90 min

credential overview

About this credential

The Oracle Database 19c: Performance Management and Tuning OCP validates performance analysis, management, and tuning skills for Oracle Database environments, including monitoring, diagnosing, and tuning instance and SQL performance problems.

Assessment

Exam details

1Z0-084

Oracle Certified Professional, Oracle Database 19c: Performance Management and Tuning

Required exam
Duration
90 min
Format
Proctored exam
Delivery
Oracle University
Passing score
60%
Proctored
Yes
View exam details

Exam blueprint

Skills measured

Skills measured16 topics
  • Basic Tuning Methods and Diagnostics
  • Using Statspack
  • Using Log and Trace Files to Monitor Performance
  • Using Metrics, Alerts and Baselines
  • Using AWR-Based Tools
  • Performing Oracle Database Application Monitoring
  • Identifying Problem SQL Statements
  • Influencing the Optimizer
  • Reducing the Cost of SQL Operations
  • Using Real Application Testing
  • SQL Performance Management
  • Tuning the Shared Pool
  • Tuning the Buffer Cache
  • Tuning the PGA
  • Using Automatic Memory Management
  • Using In-Memory Features

Before you certify

Requirements and recommended experience

Certification requirement

Oracle AI Database Administration Certified Professional

Certification requirement

Oracle Database Administration 2019 Certified Professional

Certification requirement

Oracle Database 12c Administrator Certified Professional (Retired)

Certification requirement

Pass Oracle Database 19c: Performance Management and Tuning (1Z0-084).

Reference
Recommended experience

A combination of Oracle training and hands-on experience attained via labs and/or field experience provides the best preparation for passing the exam.

Preparation

Official learning resources

Training course

Earn the Oracle Database 19c Perf Mgmt & Tuning Professional Credential

Credential lifecycle

Status, validity and renewal

Credential lifecycle

Corporate certification enablement

Turn this pathway into a team capability plan

We can align the learning path, instructor support, practice environment and delivery schedule to your team’s roles and certification target.