MANAGING MEMORY ABOUT advanced administration ABOUT manual memory management AUTOMATIC memory management MEMORY_ target MEMORY_MAX_TARGET SGA_TARGET SGA-MAX_SIZE WORKAREA_SIZE_POLICY & pga_aggressive_target USING EM & the memory advisors MONITOR in memory access mode

MANAGING STORAGE & THE SEGMENT ADVISOR MONITOR tablespaces ABOUT resumable space allocation TABLE storage management USE the segment advisor

GLOBALIZATION GLOBALIZATION settings NLS_LANG NLS_LANGUAGE & NLS_TERRITORY DATE & time localization LINGUISTIC indexes ABOUT locale builder

DIAGNOSING DATABASE PROBLEMS FAULT diagnosability infrastructure USING the alert log ABOUT the trace files DATABASE instance health snapshot USING the support workbence ENABLE oracle configuration manage

RECOVERY CONCEPTS THE backup & recovery structures ORACLE secure backup MANAGING redo data MANAGING archived redo data CHECKLIST for sound recovery

ORACLE FLASHBACK TECHNOLOGY ABOUT flashback technology SELECT…as of timestamp SELECT…as of SCN UNDO management for flashback UNDO_retention FLASHBACK table FLASHBACK drop FLASHBACK versions query FLASHBACK transaction query FLASHBACK transaction backout

MANAGING RESOURCES RESOURCE manager architecture CONSUMER groups RESOURCE plans AUTOMATIC & adaptive mapping ACTIVATING plans MONITORING resource allocation EXPLICIT consumer group switching INSTANCE caging

AUTOMATING TASKS WITH THE SCHEDULER (BASIC) SCHEDULER architecture MANAGE programs MANAGE schedules MANAGE jobs

AUTOMATING TASKS WITH THE SCHEDULER (ADVANCED) MANAGE job classes MANAGE windows & window groups MANAGE chains ABOUT events & the scheduler

MANAGING DATABASE PERFORMANCE MANAGEMENT & advisory framework MANGE AWR ADDM SQL tuning advisor SQL access advisor

INSTANCE RECOVERY ABOUT instance recovery INSTANCE recovery parallelism CHANGING recovery_parallelism MTTR advisor & tuning checkpoints LOG_CHECKPOINTS_TO_ALERT REDO logfile size advisor FAST-START ON-DEMAND parallelism

CONFIGURING RMAN RMAN architecture LAUNCE & use RMAN CONFIGURE RMAN settings ALLOCATE RMAN channels

BACKUP WITH RMAN ABOUT backup file types PERFORMING full backups PERFORMING incremental backups ESTABLISHING backup retention policy GENERATE reports REPROT unrecoverable REPORT need backup LIST incarnation

RMAN MANAGEMENT WITH EM MONITORING the flash recovery area THE EM interface to RMAN SCHEUDLING RMAN backups ORACLE-SUGGESTED backup strategy MANAGE current backups BACKUP reports MANAGE restore points

USER-MANAGED RECOVERY OPERATIONS RECOVERY concepts RECOVER temporary tablespaces RECOVER read-only tablespaces RECOVER index tablespaces RECOVER redo log group member RECREATE the password file

RECOVERY WITH RMAN COMPLETE media recovery INCOMPLETE media recovery RECOVERY using EM

USING THE RMAN RECOVERY CATALOG UNDERSTANDING catalog concepts CREATE the recovery catalog MANAGE virtual private catalogs PROTECTION of the recovery catalog USING RMAN scripts

DATABASE DUPLICATION & CLONING WHY perform database duplication? RMAN duplicate database RMAN duplicate DATABASE cloning

ADVANCED RMAN CAPABILITIES BACKUP optimization ENHANCHING parallelism, section sizes BACKUP performance & control MINIMIZE time vs. minimize load ARCHIVAL backups COPYING files between databases

TRANSPORTING TABLESPACES ABOUT tablespace transportation READ-ONLY tablespace transportation READ-WRITE tablespace transport TRANSPORT tablespaces using EM

RECOVERING FROM CURRUPTION WITH DATA RECOERY ADVISOR HOW does corruption occur? DETECTING corruption ANALYZE V$DATABASE_BLOCK-_CORRUTION view DB_BLOCK_CHECKING DB_BLACK_CHECKSUM DB_LOST_WRITE_PROTECT DB_ULTRA_SAFE USING the data recovery advisor BLOCK media recovery DBMS_REPAIR() isolation