Oracle Database 11g Release 2 for Experienced 9i Database Administrators

Delegates:

Database administrators who need to update their current Oracle 9i skills to create, administer, monitor, backup and support Oracle Database 11g.

Objectives:

This course is designed to provide the knowledge and skills needed to maintain successful and efficient day-to-day operations of Oracle Database 11g. The course will give experienced Oracle 9i database administrators practical experience in installing, configuring, administering and implementing an Oracle Database 11g. Database administrators will gain a practical understanding of the new features of Oracle Database 11g and how these can be implemented in their current Oracle installations.

Topics Covered:

• Installing Oracle Database 11g Software
• Creating an Oracle Database Using New Features
• Upgrading a Database to 11g Release 1
• The New Enterprise Manager
• Implementing New Manageability Features
• Proactive Monitoring with Database Advisors
• New Memory Management Features
• New Data Storage Features
• Automatic Storage Management
• New Space Management Features
• New Optimizer and Index Features
• New SQL and PL/SQL Features
• Improved VLDB Support
• New LogMiner Features
• The Data Pump Utility
• New Backup and Recovery Features
• New Availability Features
• New Security Features
• Automating Tasks with the New Scheduler
• Desupported and Deprecated Features
• Hot Patching
• Real Application Testing
• Use Database Replay to Capture, Process and Replay Workloads
• The Data Recovery Advisor and Flashback
• Transaction Management using Flashback and LogMiner
• Data Guard Improvements
• Using Log Miner from Enterprise Manager
• Performance Tuning New Features
• New Schema Management Functionality
• Data Warehousing Enhancements