INSTALLING ORACLE 10G DATABASE SOFTWARE • THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA) • ORACLE_BASE • ORACLE_HOME • CONFIGURE THE INSTALLATION ENVIRONMENT • INSTALLATION USING THE UNIVERSAL INSTALLER • MORE ABOUT ENTERPRISE MANAGER • REGISTER FOR SECURITY UPDATES
CREATING AN ORACLE DATABASE • CREATE A DATABASE • CONFIGURE & DROP A DATABASE • MANAGE DBCA TEMPLATES
CONTROLLING THE DATABASE ENVIRONMENT • STARTING & STOPPING DATABASE CONTROL • STARTING & STOPPING ISQL*PLUS • DATABASE LISTENER CONFIGURATION USING EM • STARTING & STOPPING THE DATABASE • HANDLING PARAMETER FILES & PARAMETER SETTINGS
MANAGING DATA: EXPORTING & IMPORTING DATA • CREATE DIRECTORY OBJECTS • ABOUT THE DATA PUMP ARCHITECTURE • DATA PUMP EXPORT • DATA PUMP IMPORT • DATA PUMP DATA DICTIONARY VIEWS • USING THE EM INTERFACE
STORAGE STRUCTURES: TABLESPACES, DATA FILES & TEMP FILES • ABOUT ORACLE 10G TABLESPACES • TABLESPACE MANAGEMENT • MORE ABOUT PERMANENT TABLESPACES • About DATABASE_PROPERTIES • MORE ABOUT TEMPORARY TABLESPACES • MORE ABOUT BIGFILE TABLESPACES • MORE ABOUT THE SYSAUX TABLESPACE • MANAGING DATA FILES
UNDO MANAGEMENT • ABOUT UNDO SPACE MANAGEMENT • CONFIGURE UNDO MANAGEMENT • UNDO_MANAGEMENT • UNDO_TABLESPACE • UNDO_RETENTION • GUARANTEE UNDO RETENTION • MONITOR UNDO SPACE • USE THE UNDO ADVISOR
PERFORMANCE MONITORING & PROACTIVE MAINTENANCE • THE MANAGEMENT & ADVISORY FRAMEWORK • MANAGING THE AUTOMATIC WORKLOAD REPOSITORY • AUTOMATIC DATABASE DIAGNOSTIC MONITOR • METRICS & ALERT THRESHOLDS • USING THE SEGMENT ADVISOR • MTTR ADVISOR & TUNING CHECKPOINTS • LOG_CHECKPOINTS_TO_ALERT • REDO LOG FILE SIZE ADVISOR • ISOLATING PERFORMANCE PROBLEMS • AUTOMATIC OPTIMIZER STATISTICS COLLECTION • GATHER_STATS_JOB
ORACLE FLASHBACK TECHNOLOGY • ABOUT FLASHBACK TECHNOLOGY • FLASHBACK QUERY • SELECT...AS OF TIMESTAMP • SELECT...AS OF SCN • FLASHBACK TABLE • FLASHBACK DROP • FLASHBACK VERSIONS QUERY • FLASHBACK TRANSACTION QUERY
FLASHBACK DATABASE • ABOUT FLASHBACK DATABASE • CONFIGURING THE FLASH RECOVERY AREA • MONITORING FLASHBACK DATABASE PERFORMANCE • FLASHBACK DATABASE CONSIDERATIONS
RMAN ENHANCEMENTS • RMAN & DATABASE RECOVERY ENHANCEMENTS • INCREMENTAL CUMULATIVE MERGE BACKUPS • CROSS-PLATFORM TRANSPORTABLE TABLESPACES
MANAGING RESOURCES • DATABASE RESOURCE MANAGER ARCHITECTURE • CONSUMER GROUPS • RESOURCE PLANS • AUTOMATIC & ADAPTIVE CONSUMER GROUP MAPPING • ENABLING & MONITORING THE RESOURCE MANAGER • EXPLICIT CONSUMER GROUP SWITCHING
AUTOMATING TASKS WITH THE DATABASE SCHEDULER (BASIC) • SCHEDULER ARCHITECTURE • MANAGE PROGRAMS • MANAGE SCHEDULES • MANAGE JOBS
AUTOMATING TASKS WITH THE DATABASE SCHEDULER (ADVANCED) • MANAGE JOB CLASSES • MANAGE WINDOWS & WINDOW GROUPS • MANAGE CHAINS • ABOUT EVENTS & THE SCHEDULER
MONITORING & MANAGING MEMORY • AUTOMATIC SHARED MEMORY MANAGEMENT • USING EM & THE MEMORY ADVISORS • MONITOR IN MEMORY ACCESS MODE
AUTOMATIC STORAGE MANAGEMENT • ASM & THE BROADER DATABASE ARCHITECTURE • DEFINING AN ASM INSTANCE • CONFIGURING STORAGE IN THE ASM INSTANCE • ASM & THE ORACLE UNIVERSAL INSTALLER • ASM & THE DBCA • USING ASMCMD • MIGRATING AN EXISTING DATABASE TO ASM
MISCELLANEOUS ENHANCEMENTS • MANAGING THE REDO LOG BUFFER • LOGMINER ENHANCEMENTS • RESUMABLE SPACE ALLOCATION ENHANCEMENT • AUDIT DATABASE ACTIVITY OPTIONS • THE PRINCIPLE OF LEAST PRIVILEGE • REGULAR EXPRESSIONS
