Installation and Upgrade Enhancements - Install Oracle Database 11g
- Upgrade your database to Oracle Database 11g
- Oracle Direct NFS
- Use online patching
Storage Enhancements - Setup ASM fast mirror resynch
- Understand scalability and performance enhancements
- Setup ASM disk group attributes
- Use various new manageability options
- Use the md_backup, md_restore, and ASMCMD extensions
Intelligent Infrastructure Enhancements - Creating and using AWR baselines
- Setting AWR Baseline Metric Thresholds
- Control Automated Maintenance Tasks
- Using Database Resource Manager New Features
- Using new scheduler features
Performance Enhancements - ADDM Enhancements
- Setup Automatic Memory Management
- Enhancements in statistics collection
Partitioning and Storage-Related Enhancements - Implement the new partitioning methods
- Employ Data Compression
- SQL Access Advisor Overview
- Create SQL Access Advisor analysis session using PL/SQL
Using RMAN Enhancements - Managing Archive logs
- Duplicating a Database
- Back up large files in multiple sections
- Perform Archival Backups
- Manage Recovery Catalogs
- Create a virtual private catalog for RMAN
| Using Flashback and Logminer - Overview of Flashback Data Archive
- Manage Flashback Data Archive
- Back-out transactions using Flashback Transaction
- Working with Logminer
Diagnosability Enhancements - Setup Automatic Diagnostic Repository
- Use Support Workbench
- Run health checks
- Use SQL Repair Advisor
Database Replay - Overview of Workload Capture and Replay
- Using Workload capture and replay
Using the Data Recovery Advisor - Overview of Data Recovery Advisor
- Repairing data failures using Data Recovery Advisor
- Perform proactive health check of the database
Security: New Features - Configure the password file to use case sensitive passwords
- Encrypt a tablespace
- Configure fined grained access to network services
Oracle SecureFiles - Use Secure File LOBS to store documents with Compression, Encryption, De-duplication, Caching
- Use SQL and PL/SQL APIs to access Secure File LOBS
| Miscellaneous New Features - Describe and use the enhanced online table redefinition
- Enhanced finer grained dependency management
- Use Enhanced DDL - Apply the improved table lock mechanism, Create invisible indexes
- Use Query Result Cache and PL/SQL Result Cache
- Adaptive Cursor Sharing
- Temporary Tablespace Enhancements
SQL Performance Analyzer - Overview of SQL Performance Analyzer
- Using SQL Performance Analyzer
SQL Plan Management - SQL Plan Baseline Architecture
- Set up SQL Plan Baseline
- Using SQL Plan Baseline Automatic SQL Tuning
- Setup and modify
Automatic SQL Tuning - Interpret reports generated by Automatic SQL Tuning
|
