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