Oracle 1Z0-078 study plan

Draw the Oracle instance memory structures (SGA components and background processes) and label the function of each, from memory

Trace a client connection end to end: listener, server process, PGA, and session, and explain where each handoff occurs

Configure a new database's key initialization parameters (memory_target or sga_target/pga_aggregate_target, db_block_size, processes) and justify each choice

Query the data dictionary views (V$SGA, V$PGASTAT, V$INSTANCE, V$PARAMETER) to confirm the configuration you set

Create and size tablespaces (smallfile and bigfile) and predict how locally managed extent allocation behaves under ASSM

Add, resize, and relocate datafiles, including online operations, and verify the result in DBA_DATA_FILES

Compare segment space management options and choose one for a write-heavy table, documenting the tradeoff

Configure and read undo tablespace usage, including retention and guaranteed undo behavior

Identify the top space consumers in a tablespace using DBA_SEGMENTS and explain each row

Configure ARCHIVELOG mode, a fast recovery area, and archived log destinations on a test database

Explain the mechanics of instance recovery versus media recovery and when each is triggered

Take a full backup with RMAN and read the resulting list backup output line by line

Configure a retention policy and observe how obsolete backups are reported

Practice a full restore and recover of a dropped tablespace to a new location

Perform incomplete recovery (time-based and SCN-based) and explain why a resetlogs open is required

Configure RMAN encryption and explain the difference between transparent, password, and dual-mode encryption

Create and use a database user with the minimum privileges needed for backup operations

Enable unified auditing, create an audit policy on a sensitive table, and query the resulting audit trail

Explain how privileged user auditing and audit trail cleanup are administered

Capture a workload with Automatic Workload Repository snapshots and generate an AWR report for a chosen interval

Read the AWR top timed events and SQL ordered by elapsed time sections and identify the dominant bottleneck

Interpret an execution plan: access paths, join methods, and where the optimizer chose poorly

Gather optimizer statistics with DBMS_STATS and explain the effect of stale or missing statistics on plan choice

Use SQL tracing and the resulting trace analysis to isolate time spent in parse, execute, and fetch

Diagnose a simulated wait event scenario and map the top wait class to a concrete corrective action

Use ADDM findings to prioritize the top two performance issues in a workload

Create a multitenant container database with two pluggable databases and connect to each service

Manage common versus local users and explain where each type can be created and authenticated

Unplug and plug a PDB into another CDB, including compatibility checking

Clone a PDB from a remote source and verify application connectivity after the clone

Configure resource limits on a PDB and observe the effect on sessions or CPU consumption

Move data with Data Pump export and import, including remapping a schema and a tablespace

Explain when transportable tablespaces are preferable to a logical export and when they are not

Set up a simple replication or standby path and describe the redo transport and apply steps

Re-run one representative practice task from each of the seven domains under a time limit

Re-derive the answer to every question you previously missed and write the underlying rule

Review the highest-risk facts: recovery sequences, wait event meanings, and PDB operations

Take a timed full-length practice set and record per-domain accuracy

Build a final weak-spot list with a concrete action for each remaining gap