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
120 min
65
60%
Professional
Registration
$245 USD
Oracle MyLearn (online proctored) or online proctoring
English
Validity
Certain Oracle Database Credentials require periodic recertification (per Oracle Certification Program Guidelines). Check Oracle's recertification policy for the most current requirements.
Take a newer version of the certification exam when available; Check Oracle Certification Program Guidelines for specific database credential recertification requirements
1Z0-183 Exam Topics and Domains
1Z0-183 is organized into 5 weighted domains. Expect to work with DBCA, ALTER PLUGGABLE DATABASE, catctl.pl, DBMS_PDB, and more.
1
Managing Multitenant Architecture
20%
Creating CDBs with DBCA and Creating Regular PDBs
Creating Container Databases using DBCACreating and Configuring Pluggable Databases
- Use Database Configuration Assistant (DBCA) to create Container Databases
- Create and configure Pluggable Databases within CDBs
- Select the 'Create as Container Database' option and specify the number of PDBs
Manage Application PDBs within CDBs
Application Container ArchitectureManaging Application PDB Lifecycle
- Create, manage, and administer Application PDBs
- Understand application container architecture
Manage CDBs and PDBs
CDB and PDB Lifecycle ManagementPDB Cloning, Relocating, and Refreshing
- Perform administrative tasks across CDB and PDB levels
- Understand CDB/PDB lifecycle management including opening/closing PDBs and resource management
Securing Multitenant Databases
Security Isolation Between PDBsCommon and Local Users, Roles, and Privileges
- Implement security isolation between PDBs
- Manage common and local users, roles, and privileges
Upgrading the Earlier Release PDB and Transporting Regular PDBs
Plugging PDBs from Earlier ReleasesTransporting PDBs Across Platforms and CDBs
- Plug PDBs from earlier releases into a 23ai CDB
- Open PDB in UPGRADE mode and run upgrade scripts (catctl.pl)
- Transport PDBs across platforms and CDBs using DBMS_PDB.DESCRIBE
2
Performing Backup and Recovery
20%
Configuring and Using RMAN
RMAN Configuration and Settings
- Configure RMAN settings including retention policies, backup destinations, channels, and compression
- Use RMAN catalog
Define Backup Strategies and Terminology
Backup Types and Strategies
- Understand full, incremental (level 0, level 1 cumulative, level 1 differential), and image copy backups
- Cumulative captures changes since last level 0
- differential captures since last level 1
Analyze and Diagnosing Failures in Database
Failure Diagnosis Tools
Use Data Recovery Advisor, V$ views, and alert logs to diagnose database failures
Apply Restore and Recovery Concepts
Restore vs Recovery
Understand the difference between restore (physical file replacement) and recovery (applying redo logs)
Performing Complete Database Recovery
Complete Recovery Using RMAN
- Perform complete recovery using RMAN
- Understand that complete recovery requires latest control file and all archived redo logs
Using Flashback Technologies for Data Recovery
Flashback Technologies
- Use Flashback Database, Flashback Table, Flashback Query, Flashback Drop (Recycle Bin)
- Understand guaranteed restore points and their effect on flashback log purging
Transporting Data Across Platforms
Cross-Platform Data Transport
- Use RMAN CONVERT TABLESPACE for cross-platform transport between systems with different endian formats
- Use Data Pump for logical transport
Duplicating Databases
RMAN Database Duplication
- Use RMAN DUPLICATE command for database cloning
- Understand active duplication vs backup-based duplication
Tune and Troubleshoot RMAN Operations
RMAN Performance Optimization
- Monitor RMAN performance using V$RMAN_STATUS
- Optimize backup parallelism and compression
3
Managing and Tuning Performance
25%
Apply Basic Tuning and Diagnostics
Basic Tuning Techniques
Use Enterprise Manager, diagnostic views (V$ views), and basic SQL tuning techniques
Using Metrics, Alerts, and Baselines
Performance Metrics and Alerting
Configure server-generated alerts, set metric thresholds, create performance baselines for comparison
Using AWR-Based Tools to Explore and Analyze AWR Data
AWR, ADDM, and ASH Reports
- Use AWR reports, AWR Compare Period Reports, ADDM reports, ASH reports
- Understand AWR Compare Period Report is for analyzing differences between two time periods
Performing Oracle Database Application Monitoring
Application Performance Monitoring
Monitor application performance, session-level diagnostics, wait events, SQL monitoring
SQL Statement Processing and Optimization
SQL Execution and Optimizer
Understand SQL execution plans, hard/soft parsing, cursor sharing, bind variables, optimizer statistics
Reducing the Cost of SQL Operations
SQL Performance Improvement Techniques
Use indexes, materialized views, result caches, SQL plan baselines, SQL profiles
Using Real Application Testing
Workload Capture and Replay
- Capture and replay database workloads
- Use SQL Performance Analyzer for testing impact of changes
Manage SQL Performance
SQL Tuning and Access Advisors
Use SQL Tuning Advisor, SQL Access Advisor, SQL Plan Management (SPM)
Tune Oracle Database Instances
Memory, I/O, and Process Tuning
- Configure memory (SGA/PGA), I/O, and process parameters
- Understand Automatic Memory Management vs manual tuning
Utilize Database In-Memory Column Store
In-Memory Column Store Architecture
- Enable and configure In-Memory Column Store
- Convert tables to columnar format in memory for accelerated scans and aggregations
- Understand dual-format architecture (row store + column store)
4
Deploying, Patching and Upgrades
15%
Install Grid Infrastructure and Oracle Database
Grid Infrastructure and Database Installation
- Install Oracle Grid Infrastructure for standalone server or RAC
- Install Oracle Database software
Creating Databases with DBCA
DBCA Database Creation Options
Use Database Configuration Assistant for database creation with various options (CDB, non-CDB)
Patching Grid Infrastructure and Databases
Patching Procedures and Tools
- Apply patches using OPatch and opatchauto
- Understand out-of-place patching
- Apply Release Updates (RU) and Release Update Revisions (RUR)
Configure Oracle Restart
Oracle Restart Configuration
Configure Oracle Restart to automatically restart database components after failures or system reboots
Upgrade Grid Infrastructure
Grid Infrastructure Upgrade
Perform rolling upgrades of Grid Infrastructure
Upgrade Oracle Database
Database Upgrade Using AutoUpgrade
- Use AutoUpgrade utility for database upgrades
- Understand pre-upgrade checks, upgrade methods, and post-upgrade tasks
- Migrate from 19c to 23ai
5
New Feature in Oracle AI Database
20%
Implement AI Vector Search
Oracle AI Vector Search
- Understand and implement Oracle AI Vector Search
- Use native VECTOR data type and specialized indexes
- Apply SQL operators for similarity comparisons (cosine distance, etc.)
- Store embeddings alongside relational data
- Integrate with RAG and enterprise LLMs
Enhance OLTP and Core Database Features
Lock-Free ReservationsWide Tables and JSON Duality Views
- Understand Lock-Free Reservations for high-concurrency OLTP workloads
- Understand Wide Tables (support up to 4096 columns)
- Use JavaScript stored procedures
- Implement JSON Relational Duality Views
Introduce Availability Features
True Cache and Data Guard Enhancements
- Understand True Cache for read-only caching
- Understand enhanced Data Guard management and improved switchover/failover
Improve Manageability and Performance
Automatic Indexing and AI-Driven Optimization
- Understand automatic indexing and AI-driven optimization
- Understand autonomous performance improvements and intelligent diagnostics
Apply Database Security Enhancements
Blockchain Tables and Security Features
- Understand Blockchain Tables for immutable data
- Understand enhanced encryption capabilities
- Understand improved auditing features and security enhancements for multitenant
How do I earn this certification?
Passing 1Z0-183 earns the Oracle AI Database Administration Certified Professional certification. It sits in the Oracle Database > Administration track.
Next Level Options
1Z0-184-25 - Oracle AI Vector Search ProfessionalSpecialization in AI Vector Search, a key new feature tested on 1Z0-183. Deepens expertise in vector data types, embeddings, and RAG integration.
Alternative Paths
- 1Z0-171 - Oracle Database 23ai SQL AssociateComplementary SQL skills certification for DBAs who want to validate SQL proficiency alongside administration.
- Oracle Cloud Infrastructure Certifications For DBAs transitioning to cloud-based Oracle Database management on OCI, including Autonomous Database and Database Cloud Service.
- Oracle Exadata Certification For DBAs working with Oracle Exadata engineered systems for high-performance database workloads.
Practice with Precision
The PlanetCert Simulator mirrors the real exam environment with authentic questions and timed pressure.
How to study for this exam?
Use the PlanetCert practice test alongside the study plan below to prepare efficiently for 1Z0-183.
What's changed on this exam?
Current Status
ACTIVE
Updates
- Oracle AI Vector Search 23ai Core exam topic in Domain 5. Candidates must understand VECTOR data type, vector indexes, similarity search operators, and RAG integration. • Release date: 2024-05-02
- Lock-Free Reservations 23ai Tested in Domain 5 under OLTP enhancements. Candidates must understand how reservations eliminate row-level lock contention. • Release date: 2024-05-02
- True Cache 23ai Tested in Domain 5 under availability features. Read-only in-memory caching layer distinct from Active Data Guard. • Release date: 2024-05-02
- Blockchain Tables 23ai (introduced in 21c, enhanced in 23ai) Tested in Domain 5 under security enhancements. Append-only immutable ledger tables for tamper-proof data storage. • Release date: 2024-05-02
- AutoUpgrade Utility 23ai Tested in Domain 4. Primary tool for upgrading Oracle databases from 19c to 23ai. • Release date: 2024-05-02
- Oracle AI Database 26ai (Rebranding) 23.26.1 Naming change only. The 1Z0-183 exam continues to cover 23ai features. The underlying database version remains 23.x with 26ai as the marketing/release update name. • Release date: 2025-10-15
Who should take this exam?
- Experience with Oracle Database administration (CDB/PDB management)
- Familiarity with RMAN backup and recovery
- SQL performance tuning experience
- Understanding of Oracle 23ai new features including AI Vector Search
- Completion of the Oracle MyLearn learning path: Earn the Oracle AI Database Administration Professional Credential