USING GLOBALIZATION SUPPORT
• Datetimes with Timezones
• Specifying Language-Dependent Behavior
• Linguistic Sorting & Comparisons
• NLS Configuration
SECURING THE ORACLE LISTENER
• Listener Password Authentication
• Controlling Database Access
• Securing the EXTPROC Service Entry
CONFIGURING RECOVERY MANAGER
• Using a Flash Recovery Area with RMAN
• Control File Autobackups
• Retention Policies
USING RECOVERY MANAGER
• Parallelization of Backup Sets
• Whole Database & Incremental Backups
• Block Change Tracking
DIAGNOSTIC SOURCES
• The Alert Log
• Viewing Alerts with EM
• Alerts Notification
• Editing Thresholds
• Trace Files
RECOVERING FROM NON-CRITICAL LOSSES
• Recreating Redo Log Files
• Recovering an Index Tablespace
• Read-Only Tablespace Recovery
• Loss of Password Authentication File
DATABASE RECOVERY
• RECOVER Command
• Types of incomplete recovery
• Recovery Using EM
• Point-in-time recovery using RMAN
FLASHBACK DATABASE
• Configuring & Monitoring Flashback Database
• Flash Recovery Area Space Usage
• Flashback Database Examples
RECOVERING FROM USER ERRORS
• Recycle Bin
• Flashback Dropped Tables Using EM
• Using Flashback Versions Query and Flashback Transaction Query
• Using EM To Flashback Tables
DEALING WITH DATABASE CORRUPTION
• The ANALYZE command
• The DBMS_REPAIR Package
• Detecting Database Corruptions Using DBVERIFY
• Using RMAN to Repair Corrupt Blocks
AUTOMATIC DATABASE MANAGEMENT
• Automatic Optimizer Statistics Collection
• Workload Repository
• Using the SQL Tuning Advisor & the SQL Access Advisor
• Automatic Undo Retention Tuning
MONITORING AND MANAGING STORAGE
• Accessing Segment & Redo Logfile Size Advisors
• Tablespace Space Usage Monitoring
• Monitoring Index Space
• Identifying Unused Indexes
AUTOMATIC STORAGE MANAGEMENT
• ASM General Architecture
• Creating tablespaces that use ASM storage
• Migrating a tablespace to use ASM storage
MONITORING AND MANAGING MEMORY
• Automatic PGA Memory Management
• Using the Memory Advisor & Automatic Shared Memory Management
MANAGING RESOURCES
• Creating a New Resource Plan & Resource Consumer Groups
• Using Sub-Plans to limit CPU Utilization
• Resource Plan Directives
AUTOMATING TASKS WITH THE SCHEDULER
• Creating a Scheduler Job
• Using Scheduler Programs
• Creating a Job Class
• Prioritizing Jobs within a Window
• Creating a job that runs a program outside of the database
