1Z0-908 study plan

Draw the Oracle instance memory and background process architecture from scratch, labeling SGA components (buffer cache, shared pool, redo log buffer, large pool, Java pool) and their sizing parameters

Identify which dynamic performance views (V$SGA, V$SGAINFO, V$BUFFER_POOL, V$PARAMETER) report each memory structure and practice querying them on a lab database

Create and resize tablespaces with AUTOEXTEND, uniform versus autoallocate extent management, and locally managed extent allocation, then verify results in DBA_TABLESPACES and DBA_DATA_FILES

Configure the server parameter file (SPFILE) and demonstrate the difference between SCOPE=MEMORY, SCOPE=SPFILE, and SCOPE=BOTH when changing parameters

Explain segment, extent, and block relationships and locate a table's segment header using DBA_SEGMENTS and DBMS_SPACE

Implement automatic undo management: create an undo tablespace, set UNDO_RETENTION and RETENTION GUARANTEE, and observe undo usage in V$UNDOSTAT

Enable and tune the redo log configuration by adding or dropping online redo log groups and members and querying V$LOG and V$LOGFILE

Configure the Fast Recovery Area with the correct size and retention policy and confirm its use in V$RECOVERY_FILE_DEST

Automate space monitoring by writing a query that flags tablespaces above 80 percent usage and segments that cannot extend

Configure ARCHIVELOG mode on a lab database and verify archived log destinations in V$ARCHIVE_DEST and V$ARCHIVED_LOG

Perform a consistent whole-database export with Data Pump and a physical cold backup, then restore each into a separate lab environment

Execute complete and incomplete media recovery of a database in ARCHIVELOG mode using RMAN, including recovery to a point in time via SET UNTIL

Take incremental level 0 and level 1 RMAN backups and explain how the change tracking and block change tracking files reduce backup time

Diagnose and resolve an ORA-01555 snapshot too old error by adjusting undo retention and explaining read consistency in rollback segments and undo

Explain transaction isolation, statement-level read consistency, and how undo data supports both rollback and flashback query

Install Oracle Database software silently using a response file and create a database with DBCA in silent mode, capturing the logs

Apply a release update and a one-off patch with OPatch, then verify the inventory with opatch lspatches and datapatch

Create a common user and a local user, grant system and object privileges, and demonstrate the difference between direct grants and roles

Configure a password profile with FAILED_LOGIN_ATTEMPTS and PASSWORD_LIFE_TIME and test account lockout and expiry behavior

Set up a database user with the minimum privileges needed to connect and query a single application schema, then audit the privilege set

Create a pluggable database from the seed and clone it with CREATE PLUGGABLE DATABASE, then open, close, and switch containers with ALTER SESSION SET CONTAINER

Back up and recover an individual PDB with RMAN and with Data Pump, and explain which operations require the CDB root

Configure and verify local undo in a multitenant database and explain how common versus local users resolve across containers

Automate a nightly backup schedule with Oracle Scheduler jobs and verify job history in DBA_SCHEDULER_JOB_LOG

Test a tablespace point-in-time recovery or flashback database operation and document when each is preferable

Capture an AWR snapshot pair under a synthetic workload and interpret the top timed events, wait classes, and SQL ordered by elapsed time

Use Statspack or AWR reports to identify the highest-load SQL and propose an index or SQL change, then measure the improvement

Configure the automatic workload repository retention and baseline settings appropriate for a lab instance and query DBA_HIST views

Diagnose lock contention by reproducing a blocking session and resolving it with V$SESSION blocking_session and V$LOCK

Tune PGA memory with PGA_AGGREGATE_TARGET and observe work area executions in V$PGASTAT and V$SQL_WORKAREA

Configure the local listener and a tnsnames.ora entry, then test connectivity with tnsping and a SQL*Plus connection using easy connect and a full descriptor

Explain and demonstrate naming methods including local naming, easy connect, and directory naming, and choose the right one for a given scenario

Tune the shared pool and library cache by examining V$LIBRARYCACHE and the shared pool advisory, and explain bind variable peeking and cursor sharing

Use the SQL Tuning Advisor and SQL Access Advisor on a sample statement and interpret their recommendations

Configure a database service and connect a client through it, verifying service registration in V$SERVICES and listener status

Build an Oracle Scheduler chain or window that runs a Data Pump export on a recurring schedule and verify it in DBA_SCHEDULER_JOBS

Use external tables or SQL*Loader to load a flat file into a table and validate row counts and rejected rows

Re-run two full-length practice exams under timed conditions and log every missed question by domain

Revisit the two domains with the lowest practice scores and rewrite the relevant architecture, security, or automation notes from memory

Produce a final one-page cheat sheet of parameter names, view names, and command syntax you repeatedly missed