• Decrease font size
  • Default font size
  • Increase font size

Oracle 11g New Features

 Print E-mail

Course Length - 3 Full Days or 5 half-days

This course gives students the opportunity to learn about and practice with the new features and enhancements in Oracle Database 11g Release 1. Students examine the benefits and use of the new features in hands-on practice sessions to reinforce their understanding of the new capabilities in Oracle Database 11g Release 1.

At the end of this course the students should be able to:

  • Understand the Upgrade Paths to Oracle 11g Release 1
  • Use the SQL Performance Analyzer
  • Record and Replay Workloads
  • Use the Automatic Database Diagnostic Monitor Enhancements
  • Understand the New RMAN capabilities
  • Manage a Flashback Data Archive
  • Use the Data Recovery Advisor
  • Understand and use the New Diagnostic Monitoring Features
  • Identify the Application Development New Features and Enhancements

Who Should Attend

Oracle Database Administrators.

Prerequisites

At least 6 months of Oracle Database Administration experience.

Outline

Oracle Database 11g Release 1: Upgrade Paths

Performance Enhancements

  • Automatic SQL Tuning
  • Selecting Potential SQL Statements for Tuning
  • SQL Performance Analyzer Overview
  • SQL Performance Analyzer Data Dictionary Views
  • SQL Plan Management Overview
  • SQL Plan Baseline Architecture
  • Automatic Workload Repository Baselines
  • Performance Monitoring and Baselines
  • ADDM Enhancements
  • Automatic Memory Management
  • Monitoring Automatic Memory Management
  • Database Replay
  • Supported Workloads

Backup and Recovery Enhancements

  • Data Recovery Advisor
  • Repairing Data Failures
  • Proactive Checks
  • Setting Parameters to Detect Corruption
  • RMAN New Features and Enhancements

Flashback and LogMiner Enhancements

  • New and Enhanced Features for Flashback and LogMiner
  • Flashback Data Archive
  • Flashback Transaction Backout
  • Flashback Transaction Wizard

Diagnostic Enhancements

  • Automatic Diagnostic Repository
  • Incident Packaging Service
  • OEM Support Workbench Overview
  • Health Monitor Overview
  • Improved Block Corruption Detection
  • SQL Repair Advisor
  • Hang Manager

Security Enhancements

  • Built-in Password Complexity Checker
  • Built-in User Profile
  • Managing Default Audits
  • Tablespace Encryption
  • Oracle SecureFiles Overview

Storage Enhancements

  • Partitioning Enhancements
  • Automatic Storage Management New Features and Enhancements

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

Miscellaneous New Features

  • DDL with the WAIT Option
  • Invisible Index Overview
  • Simplified Temporary Tablespace Management
  • Read-Only Tables
  • Data Pump Enhancements
  • Automatic UNDO Management Default Setting