WA1633 Oracle 11g New Features for Developers Training and Courseware Course Outline

1. Oracle Database 11g Release 1: Upgrade Paths

 

2. Application Development New Features

  • Client-Side Query Cache
  • Sequences in PL/SQL Expressions
  • Named and Mixed Notation for PL/SQL Programs in SQL
  • New Compound Trigger Type
  • PL/Scope
  • PL/SQL CONTINUE Statement
  • SIMPLE_INTEGER Data Type
 

3. Performance Enhancements

  • Automatic SQL Tuning
  • SQL Performance Analyzer Overview
  • SQL Performance Analyzer Data Dictionary Views
  • SQL Plan Management Overview
  • SQL Plan Baseline Architecture
 

4. Miscellaneous New Features and Enhancements