Oracle Database 11g New Features - 5 Days
Students will learn in a combination of lecture and hands-on labs.
| Day 1 | |
| AM | PM |
| Installing Oracle Database 11g | Fault Dianosability Infrastructure Overview |
| Upgrade to Oracle Database 11g | ADR |
Supported Upgrade Methods |
Using adrci |
DBUA |
LAB: Using adrci |
Manual Upgrades |
Oracle Database 11g Health Checkers |
Using Exp/Imp |
LAB: Using the Health Checkers |
SQL*Plus Copy |
Support Workbench |
LAB: Upgrade an Oracle 10gR2 Database to Oracle 11g using the DBUA |
LAB: Using the Support Workbench |
| Partitioning in 11g | |
Interval Partitioning |
|
Extended Composite Partitioning |
|
Reference Partitioning |
|
System Partitioning |
|
LAB: Explore 11g Partitioning |
|
| Statistics Features | |
Pending and Published Statistics |
|
Recovering Previous Statistics |
|
Extended Statistics |
|
| Day 2 | |
| AM | PM |
| RMAN Features | Data Pump Features |
Interfile Backup Parallelism |
Deprecation of EXP |
Compression Changes |
Compression |
Security |
Improvement in Excryption |
Active Database Duplication |
Data Remapping |
Improved Handling of Long-Term Backups |
Table Renaming |
Backup Failover for Archived Redo Logs |
Data Pump and Partitioned Table Operations |
Recovery Catalog Enhancements |
Overwrite Dump Files |
Undo Backup Optimization |
The data_options parameter |
Block Media Performance Improvements |
The transportable parameter |
Improved RMAN Scripting |
LAB: Explore Oracle Data Pump |
Backup of Read-Only Transportable Tablespaces |
SQL*Plus Features |
LAB: Explore RMAN Features in 11g |
SQL Features in 11g |
| The Data Recovery Advisor | PL/SQL Features in 11g |
Introduction to the Data Recovery Advisor |
|
Using the Data Recovery Advisor with OEM |
|
Manually Using the Data Recovery Advisor |
|
| Day 3 | |
| AM | PM |
|
Flashback Database Features in 11g |
Automatic Memory Management (AMM) |
Oracle Flashback Transaction Backout |
Introduction to AMM |
Oracle Flashback Data Archives |
|
LAB: Explore Oracle Flashback Features in 11g |
V$MEMORY_TARGET_ADVICE |
| SQL Access Advisor Features in 11g |
V$MEMORY_RESIZE_OPS |
Partitioned Table Advice |
OEM and AMM |
LAB: Using SQL Access Advisor to Determine if a Table Should be Partitioned |
LAB: Managing AMM |
| SQL PLAN Management | Resource Manager Features |
| Automatic SQL Tuning |
IO Calibration |
The Default Maintenance Plan |
|
Built-in Resource Plans |
|
Resource Manager Statistic Histories Stored in AWR |
|
Resource Manager Plan New Directives |
|
LAB: Resource Manager in 11g |
|
| Parameter File Management | |
Read/Write Error Handling of SPFILES |
|
Easier Conversion to the Use of SPFILES |
|
Users are Prevented from Setting Invalid Values in SPFILES |
|
| Day 4 | |
| AM | PM |
| ADDM Features in 11g | Real Application Testing - Database Replay |
New ADDM-related Views |
Database Replay Overview |
ADDM is Now RAC aware |
Database Replay Capture |
dbms_addm |
Database Replay Prepare |
Classifications |
Database Replay |
Directives |
LAB: Using Database Replay |
LAB: Exploring ADDM in 11g |
Real Application Testing / SQL Performance Analyzer |
| AWR Features in 11g |
SQL Performance Analyzer Overview |
Default Retention of AWR Snapshots Changed |
Using the SQL Performance Analyzer via OEM |
New AWR Baseline Features |
Using the SQL Performance Analyzer Manually |
Adaptive Metric Thresholds |
LAB: Using SQL Performance Analyzer |
LAB: Exploring AWR in 11g |
Virtual Columns |
| Automatic Maintenance Tasks |
About Virtual Columns |
Overview of Automatic Maintenance Tasks |
Partitioning with Virtual Columns |
Managing Automatic Maintenance Tasks |
LAB: Using Virtual Columns |
LAB: Dealing with Automatic Maintenance Tasks |
|
| Day 5 | |
| AM | PM |
| ASM Features in 11g | 11g Maintenance-related Features |
New Documentation |
Finer-grained Dependencies |
ASM Disk Group Attributes |
DDL Wait Option |
ASM Fast Disk Resync |
New Add Column Functionality |
ASM Compatibility Attributes |
Table Compression |
ASM Preferred Mirror Read |
New ddl_lock_timeout Parameter |
ASM Rolling Upgrade |
New lock_table Parameter |
LAB: ASM Features in 11g |
Fewer Exclusive Locks Taken During Online Operations |
| Security Changes in 11g |
Invisible Indexes |
Auditing |
11g Pivot and Unpivot Clauses |
Passwords |
The Pivot Clause |
Fine-Grained Access Control (FGAC) |
The Unpivot Clause |
Tablespace Encryption with Transparent Data Encryption (TDE) |
LAB: Using the Pivot and Unpivot Clauses |
Other TDE-related Enhancements |
|
Oracle SECUREFILE LOBS |
|
LAB: Security |
- Item #: FREEMAN05
