Session 1: NEW MANAGEMENT FEATURES
- Automatic Diagnostic Repository (ADR)
- Parameter file management changes
- Automatic Memory Management
Session 2: INSTALLING ORACLE DATABASE 11G
- Oracle Grid Infrastructure and Oracle Restart
- Installing Oracle Database 11g
- The DBCA
- Online patching
Session 3: UPGRADE TO ORACLE 11G
- Changes in 11g Release 1 and 2
- Upgrade to Oracle Database 11g Release 2
- New parameters
- Deprecated parameters
- Obsolete parameters
Session 4: DATABASE SECURITY ENHANCEMENTS
- Case sensitive passwords
- Default password
- Privileges audited by default
- Password verify function
- Transparent tablespace encryption
- Fine grained access to database network services
- Data masking
- Securefile LOBs
- Security and OEM
Session 5: ADDM AND AWR NEW FEATURES
- ADDM New features
- AWR New features
Session 6: NEW SCHEDULER FEATURES
- Auto Task overview
- Auto Task architecture
- Auto Task dictionary views
- Use OEM to manage Auto Task
- Manage Auto Task manually
- The Auto Task maintenance windows
- Email Notification
- File Watcher
- Remote Database Jobs
- Multiple Destination Jobs
Session 7: SCHEMA MANAGEMENT NEW FEATURES
- DDL wait option
- Add columns with default value
- Virtual columns
- Invisible indexes
- Read only tables
Session 8: APPLICATION DEVELOPMENT NEW FEATURES
- New SQL commands
- Lock table parameter
- Client side caching
- Server result cache
- Named notation
- PL/SQL function cache
- PL/SQL native compilation
- Natural sequences
- When Others Then Null
- Create trigger as enabled or disabled
- Compound triggers
- Create trigger follows clause
- PL/SQL Continue statement
Session 9: NEW AND ENHANCED UTILITIES PREVENTING AND DETECTING DATA CORRUPTION
- Automatic block corruption reporting
- Automatic quarantine of corrupt undo segments
- Protection from data corruptions
- Improvements to ANALYZE ... VALIDATE STRUCTURE
- Proactive Monitoring with the Health Monitor
Session 10: RMAN ENHANCEMENTS
- RMAN ENHANCEMENTS
- Automatic channel failover
- Parallel backup and restore for very large files
- Multisection backups
- Improved handling of long-term backups
- Backup failover for archived redo logs
- Archived redo log deletion policy
- Undo backup optimization
- Improved block corruption detection
- Improved block media recovery
- Substitution variables
- Compressed backups
- Virtual private catalogs
- Merge catalogs
- Backup a recovery catalog
Session 11: DATA RECOVERY ADVISOR
- Data Recovery Advisor overview
- DRA through the RMAN command line
- Use DRA through OEM
Session 12: FLASHBACK DATA ARCHIVE
- Flashback history
- Flashback transaction backout
- Transaction management with LogMiner and Flashback Data Archive
- LogMiner Interface in OEM
- Oracle Total Recall
- Create a Flashback Data Archive
- Flashback query
Session 13: DATABASE REPLAY
- Overview of Database Replay
- The Database Replay process
- Capture a workload
- Pre process the captured workload
- Replay the workload
- Database Replay usage
- The DBMS_WORKLOAD Packages
Session 14: DATA PUMP NEW FEATURES
- The exp utility deprecated
- Dump file set compression
- Encryption enhancements
- Rename table
- Dumpfile overwrite
- Partitioned tables
- The transportable parameter
- The data options parameter
- Data Pump legacy mode
Session 15: STANDBY DATABASE
- RMAN duplicate database
- Active database duplication
- Snapshot standby database
- Real time query
- Lost write protection
Session 16: ORACLE DATABASE ADVISORS
- Repair advisors and fault diagnostics
- The SQL Repair Advisor
- The SQL Access Advisor
- The Streams Performance Advisor
- New DBA Advisor views
Session 17: ASM CHANGES AND NEW FEATURES
- SYSASM role
- Disk group attributes
- Fast disk resync
- Preferred mirror read
- Support for variable extent sizes
- Drop diskgroup force
- Metadata backup and restore
- ASM Cluster File System (ACFS)
- ASM Dynamic Volume Manager (DVM)
- ASM intelligent datapPlacement
- ASM File Access Control
Session 18: DIAGNOSTICS NEW FEATURES
- Fault diagnostic automation
- Automatic diagnostic workflow
- Problems and incidents
- Incident packaging service
- EM Support Workbench
Session 19: PERFORMANCE TUNING NEW FEATURES
- Improved statistics gathering
- Real time SQL monitoring
- SQL Performance Analyzer
- Intelligent cursor sharing
- SQL Plan management
- Temporary tablespace shrink
- Test Case Builder
Session 20: NEW DATA WAREHOUSE AND BI FEATURES
- Partitioning enhancements
- Materialized view enhancements
- Query rewrite enhancements
- PIVOT and UNPIVOT commands
- Data compression
- Enhancements to the degree of parallelism
- In memory parallel query
Session 21: RESOURCE MANAGER CHANGES AND NEW FEATURES
- I/O calibration
- Resource Manager new features
- Default maintenance plan
- New built in plans
- Resource Manager statistics in AWR
- Instance Caging