MANAGING MEMORY • ABOUT MANUAL MEMORY MANAGEMENT • AUTOMATIC MEMORY MANAGEMENT • MEMORY_TARGET • MEMORY_MAX_TARGET • SGA_TARGET • SGA_MAX_SIZE • WORKAREA_SIZE_POLICY & PGA_AGGREGATE_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 • PCTFREE Illustrated • USE THE SEGMENT ADVISOR • Using The SHRINK SPACE Option • CASCADE To Dependent Objects • Optionally Call DELETE_TASK()

MANAGING RESOURCES • DATABASE RESOURCE MANAGER ARCHITECTURE • CONSUMER GROUPS • RESOURCE PLANS • AUTOMATIC & ADAPTIVE CONSUMER GROUP MAPPING • ACTIVATING PLANS • MONITORING RESOURCE ALLOCATION • EXPLICIT CONSUMER GROUP SWITCHING

AUTOMATING TASKS WITH THE SCHEDULER (BASIC) • SCHEDULER ARCHITECTURE • RAC Environment • 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

GLOBALIZATION • GLOBALIZATION SETTINGS • NLS_LANG • NLS_LANGUAGE & NLS_TERRITORY • DATE & TIME LOCALIZATION • LINGUISTIC INDEXES • ABOUT LOCALE BUILDER

DIAGNOSING DATABASE PROBLEMS • ABOUT THE FAULT DIAGNOSABILITY INFRASTRUCTURE • ADR Highlights From EM • USING THE ALERT LOG • ABOUT THE TRACE FILES • DATABASE INSTANCE HEALTH SNAPSHOT • USING THE SUPPORT WORKBENCH • ENABLE ORACLE CONFIGURATION MANAGER

AUTOMATIC STORAGE MANAGEMENT • ASM & THE BROADER DATABASE ARCHITECTURE • CREATING THE ASM INSTANCE • ADMINISTERING THE ASM INSTANCE • SYSASM Super Administrator • ASM Storage Parameters • Using DBCA • Using ASMCMD • CONFIGURING DATABASES FOR ASM STORAGE • DBCA • DBUA • ASM Migration Using EM

RECOVERY CONCEPTS • ABOUT THE BACKUP & RECOVERY STRUCTURES • MANAGING REDO DATA • Is LOG_BUFFER Large Enough? • What V$LOG Reveals • What V$LOG_HISTORY Reveals • What V$LOGFILE Reveals • What V$ARCHIVED_LOG Reveals • MANAGING ARCHIVED REDO DATA • ARCHIVELOG Status • CREATING A FOUNDATION FOR SOUND RECOVERY

ORACLE FLASHBACK TECHNOLOGY • ABOUT FLASHBACK TECHNOLOGY • FLASHBACK QUERY • SELECT...AS OF TIMESTAMP • SELECT...AS OF SCN • Using DBMS_FLASHBACK() • CONFIGURING UNDO MANAGEMENT FOR FLASHBACK • UNDO_RETENTION • FLASHBACK TABLE • FLASHBACK DROP • FLASHBACK VERSIONS QUERY • FLASHBACK TRANSACTION QUERY • FLASHBACK TRANSACTION BACKOUT

FLASHBACK DATABASE • ABOUT FLASHBACK DATABASE • CONFIGURING THE FLASH RECOVERY AREA • More About DB_RECOVERY_FILE_DEST • PERFORMING DATABASE FLASHBACK • MONITORING FLASHBACK PERFORMANCE • FLASHBACK DATABASE CONSIDERATIONS • CONFIGURE FLASHBACK DATA ARCHIVE

INSTANCE RECOVERY • ABOUT INSTANCE RECOVERY • SMON Process & Instance Recovery • PMON Process & Process 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 • RMAN Sample Backup Session • LAUNCH & USE RMAN • CONFIGURE RMAN SETTINGS • ALLOCATE RMAN CHANNELS

BACKUP WITH RMAN • ABOUT BACKUP FILE TYPES • PERFORMING FULL BACKUPS • PERFORMING INCREMENTAL BACKUPS • ESTABLISHING A BACKUP RETENTION POLICY • GENERATE REPORTS • REPORT UNRECOVERABLE • REPORT NEED BACKUP • LIST INCARNATION • VALIDATE BACKUP DATA INTEGRITY

RMAN MANAGEMENT WITH EM • MONITORING THE FLASH RECOVERY AREA • THE EM INTERFACE TO RMAN • SCHEDULING RMAN BACKUPS • USING THE 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 • TSPITR • DBPITR • RECOVERY USING EM