Module 1: Planning Your Upgrade to Oracle Database 11g

• Steps to Upgrade to Oracle Database 11g
• Choosing an Upgrade Method
• Performing Character Conversion

 Module 2: Upgrading the Oracle Database 11g

• Installing Oracle Database 11g Software
• Applying Oracle Software Patches
• Creating a Database

 Module 3: Real Application Testing

• Why Use Database Replay?
• Pre-Change Production System
• Capture / Replay Considerations
• Performing Workload Capture
• Performing Workload Replay
• Using SQL Performance Analyzer
• Using Database Replay to test system changes
• Using SQL Performance Replay to test SQL changes

 Module 4: Upgrading Your Database Using other Methods

• Using DBUA to Upgrade the Database
• Oracle Database 11g: Upgrade Enhancements
• Backing Up the Database Before Upgrade
• Using the Preupgrade Information Tool
• Using New Postupgrade Status Utility

 Module 5: Performing Post-Upgrade Steps

• Upgrading Server Manager scripts
• Performing Additional Upgrade Tasks
• Using New Features in Your Upgraded Database
• Executing the Postupgrade Script
• Upgrading the National Character Set toAL16UTF16
• Checking for Unusable Function-based Indexes
• Upgrading the Recovery Catalog

 Module 6: Using EM: Database Control and Grid Control

• Administering the Database Using Enterprise Manager: Overview
• Using Database Control
• Granting Database Control Administrative Privileges
• Using Grid Control to Manage Your Environment
• Setting Preferred Credentials

 Module 7: Proactively Maintaining the Database

• Oracle Database 11g: Self-Managing Database
• Automatic Workload Repository
• Job Scheduler Concepts
• Server-Generated Alerts
• Advisor Framework
• Automatic Database Diagnostic Monitor
• Configuring Alerts

 Module 8: Managing System Resources

• Database Resource Manager: Concepts (auto enabled)
• Using New Features of Database Resource Manager
• Exploring Allocation methods
• Maximum Estimated Execution Time
• Automatic Consumer Group Switching
• Using Resource Manager Statistics

 Module 9: Automating Tasks with the Scheduler

• Scheduler Concepts
• Using Scheduler Programs
• Windows and Resources
• Administering the Scheduler

 Module 10: Managing Memory Structures

• Enabling Automatic Memory Management
• Modifying Parameters for Automatically Managed Components
• Modifying Parameters for Manually Sized Components
• Monitoring Automatic Memory Management

 Module 11: Managing Database Storage Structures

• Using the SYSAUX Tablespace
• Specifying a Default User Tablespace
• Using Oracle Managed Files (OMF
• Creating Bigfile Tablespaces
• Using Nonstandard Block Sizes
• Proactively Monitoring Tablespaces
• Using the Redo Logfile Sizing Advisor

 Module 12: Implementing Automatic Storage Management (ASM)

• ASM: Key Features and Benefits
• ASM: General Architecture
• Accessing an ASM Instance
• ASM Administration
• Database Instance Parameter Changes
• Migrating Your Database to ASM

 Module 13: Managing Database Space

• Understanding Automatic Undo Management
• Specifying the Undo Management Mode
• Setting the Undo Management Initialization Parameters
• Using the Undo Advisor

 Module 14: Administering Users and Database Security

• Unlocking Default User Accounts
• Specifying a Common Password for System
• Securing access by user
• Using Fine-Grained Auditing
• Auditing the SYS User
• Understanding Changes to the Audit Trail

 Module 15: Managing Schema Objects

• Using Automatic Segment-space Management
• Estimating Table and Index Size Before Creation
• Granting Object Privileges on Behalf of the Object Owner
• Performing Online Redefinition of Tables
• Enabling Data Segment Compression
• Automatically Collecting Statistics
• Using the Segment Advisor

 Module 16: Accessing and Loading Data

• Using Data Pump to Import and Export Data
• Managing External Tables
• Cross-Platform Transportable Tablespaces

 Module 17: Performing Backup and Recovery Operations

• Using RMAN to Back up the SPFILE
• Creating Change-aware Incremental Backups
• Encrypting backups
• Using backup compression
• Using RMAN to Perform Recovery: Automatic File Creation During Recovery
• Performing Trial Recovery
• Enabling and Performing Flashback Database

 Module 18: Recovering From User Errors

• Using Flashback Query
• Auditing and Recovering Transactions Using the Flashback Transaction Query Feature
• Retrieving Row History Information Using the Flashback Version Query Feature
• Recovering Table Data Using the Flashback Table Feature
• Recovering Dropped Tables using Flashback Drop Feature
• Flashing back a transaction
• Using LogMiner Enhancements

 Module 19: Managing Performance

• Using the SQL Tuning Advisor
• Using the SQL Access Advisor
• Using the trcsess Utility to Consolidate Output from Trace Files
• Using DBMS_MONITOR

 Module 20: Diagnosability Enhancements

• Oracle Database 11g Fault Management
• Ease Diagnosis: Automatic Diagnostic Workflow
• Automatic Diagnostic Repository
• Incident Packaging Configuration
• Running Health Checks
• Using the SQL Repair Advisor
• Viewing, Disabling, or Removing a SQL Patch

 Module 21: Miscellaneous New Features

• Managing & Using SQL Query Result Cache
• Adaptive Cursor Sharing: Architecture
• Temporary tablespace shrinkage
• Using the client result cache

Oracle Database 11g: New Features for Oracle 9i DBAs Course Prerequisites:

• A solid understanding of the Oracle database architecture
• Knowledge of database administration fundamentals
• Knowledge of Oracle 9i database tools and utilities
• Experience in configuring and managing an Oracle 9i database
• Familiarity with the Oracle RMAN utility