Oracle Database Administration Training (OCP)
0% Completed
M1 — Instance Architecture, Memory and Processes
Instance startup, shutdown modes and the order the background processes start
Reading
SGA components: buffer cache, shared pool, redo log buffer and large pool
Reading
Automatic Memory Management sizing and how PGA advice is applied
Reading
Foreground and background processes: DBW, LGWR, CKPT, ARC and MMON
Reading
Reading V$SGA, V$SGASTAT and V$PROCESS to confirm a sizing decision
Reading
Diagnosing an instance problem with the alert log, trace files and ADR
Reading
M2 — Logical and Physical Storage, Tablespaces and Undo
Segments, extents, blocks and how they stack inside a tablespace
Reading
Creating tablespaces with datafiles, uniform size and bigfile settings
Reading
Autoextend, manual resize and an online datafile move with no downtime
Reading
Reclaiming space with segment shrink, deferred creation and compression
Reading
Automatic undo, undo retention and the ORA-01555 snapshot-too-old failure
Reading
Using segment advisor and tablespace map to find and release waste
Reading
M3 — SQL and PL/SQL for the Administrator
Writing set-based DDL and DML that a batch job can safely rerun
Reading
Substitution variables, DEFINE and VERIFY in a SQL*Plus script
Reading
PL/SQL block structure, exception handling and record and row types
Reading
Building packages, cursors and parameterised procedures for routine tasks
Reading
Dynamic SQL with EXECUTE IMMEDIATE for objects that do not exist yet
Reading
Moving data with SQL*Loader, external tables and Data Pump row handling
Reading
M4 — Indexes, Optimizer Behaviour and Execution Plans
B-tree, bitmap and function-based indexes and the workload each one suits
Reading
Building composite indexes with the first column the predicate needs
Reading
Reading EXPLAIN PLAN output and the DBMS_XPLAN DISPLAY cursor form
Reading
Adaptive plans, SQL plan baselines and holding a plan steady through change
Reading
Gathering statistics with DBMS_STATS and reading histogram behaviour
Reading
Running SQL Tuning Advisor and a full SQL Plan Management workflow
Reading
M5 — Backup, Recovery, RMAN and Flashback
Full, incremental level 0 and level 1 backups with block change tracking
Reading
Setting the recovery objective: RTO, RPO and the archived log trail
Reading
Restoring and recovering a database with RMAN in the practice environment
Reading
Point-in-time recovery with a RECOVER UNTIL clause and log sequence handling
Reading
Log mining behind flashback query, version and transaction recovery
Reading
Flashing back a database to a point in time after a dropped table
Reading
M6 — Data Guard, Multitenant and Availability
Primary, physical standby and logical standby roles in a Data Guard setup
Reading
Configuring a standby with ARCHIVELOG mode and a redo transport service
Reading
Managing standby redo apply, a role change and a planned switchover
Reading
Performing a failover and re-seeding a standby database afterwards
Reading
Creating a pluggable database, saving it and moving it between CDBs
Reading
Resource Manager limits that stop one PDB starving the rest of the CDB
Reading
M7 — Security, Upgrades, Patching and the OCP Path
Users, roles, profiles, tablespace quotas and least-privilege grants
Reading
Unified auditing, audit trail review and password policies in the database
Reading
Applying a patch set with OPatch and checking for configuration drift
Reading
Planning a 19c upgrade with the pre-upgrade tool and a tested rollback
Reading
Working through the 1Z0-082 and 1Z0-083 objective lists one item at a time
Reading
Timed practice papers, question elimination and the exam-day plan
Reading
M8 — Capstone: Administer and Recover a Production Database
Stand up an instance with tablespaces, users, quotas and a scheduled job
Reading
Load a data set and build only the indexes the workload profile justifies
Reading
Capture a full and an incremental backup and prove the recovery point
Reading
Simulate a user error and recover to the minute before the table drop
Reading
Build a standby database and perform both a switchover and a failover
Reading
Write the runbook, the backup policy and the exam revision plan
Reading
📞
Enroll Now
Start Your Journey
Fill in your details and our team will get back to you within 24 hours