Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

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