Who should attend
- Database administrators
- Developers
- Technical consultants
Prerequisites
- Strong Oracle Database 10g concepts
- Oracle Database 10g: New Features for Administrators Release 2
- Oracle Database 10g: Administration Workshop II Release 2
Course Objectives
- Use the SQL Performance Analyzer
- Upgrade your database to 11g Release 1
- Record and replay workloads
- Use the automatic database diagnostic monitor
- Explore advanced RMAN capabilities
- Manage a flashback data archive
- Use the data recovery advisor
- Setup and use ASM
Product Description
- Oracle Database 11g: Installation and Upgrade Enhancements
- Installing and Upgrading to Oracle Database 11g
- Database Creation and Hot Patching
- Oracle Database 11g: Storage Enhancements
- ASM Administration
- ASM Commands and Extensions
- Oracle Database 11g: Change Management Overview and SQL Plan Management
- Change Management and SQL Performance Analyzer
- SQL Plan Management
- Oracle Database 11g: Database Replay and Automatic SQL Tuning
- Database Replay in Oracle Database 11g
- Automatic SQL Tuning in Oracle Database 11g
- Oracle Database 11g: Intelligent Infrastructure Enhancements
- Automatic Workload Repository Baselines
- I/O Resource Calibration and Lightweight Jobs
- Oracle Database 11g: Performance Enhancements
- ADDM, AMM, and Statistics Enhancements
- Oracle Database 11g: Partitioning and Storage-Related Enhancements
- New Partitioning Methods and SQL Access Advisor
- Oracle Database 11g: Using RMAN Enhancements, Flashback and LogMiner
- Using RMAN Enhancements
- Using Flashback and LogMiner
- Oracle Database 11g: Diagnostic Enhancements and Using the Data Recovery Advisor
- Diagnostic Enhancements in Oracle Database 11g
- Using the Data Recovery Advisor
- Oracle Database 11g: New Security Features
- New Security Features in Oracle Database 11g
- Oracle Database 11g: SecureFiles and Miscellaneous New Features
- SecureFiles in Oracle Database 11g
- Miscellaneous New Features in Oracle Database 11g