Oracle Database 11g Release 2 for Experienced 10g Database Administrators

Delegates:

Database administrators who need to update their current Oracle Database 10g 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 operation of Oracle Database 11g. The course will give experienced Oracle 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
• Enterprise Manager Changes
• Hot Patching
• SQL New Features
• PL/SQL New Features
• New Memory Management Features
• Real Application Testing
• Use Database Replay to Capture, Process and Replay Workloads
• Setup and Use ASM New Features
• The Data Recovery Advisor and Flashback
• Transaction Management using Flashback and LogMiner
• RMAN New Features
• Data Pump Data Compression
• Data Guard Improvements
• Using Log Miner from Enterprise Manager
• Performance Tuning New Features
• New Security Features
• New Schema Management Functionality
• Data Warehousing Enhancements
• Miscellaneous New Features
• Desupported and Deprecated Features