Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Oracle 11g > Oracle 11g New Features Overview Training

Oracle 11g New Features Overview Training

Course#: WA1634

This one (1) day course gives students the opportunity to learn about the new features and enhancements in Oracle Database 11g Release 1 to help them plan their use of the Oracle 11g features. This instructor-led lecture is supported by appropriate and detailed demonstrations.

Objectives 

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

  • Understand the Oracle 11g Release 1 New Features and Enhancements 

Audience

Management, Oracle Database Administrators and Developers. 

Prerequisites  

A basic understanding of the Oracle Architecture and its concepts.

Duration

One day

Outline of WA1634 Oracle 11g New Features Overview Training

1. Oracle Database 11g Release 1: Upgrade Paths

2. Performance Enhancements 

  • Automatic SQL Tuning
  • SQL Performance Analyzer Overview
  • SQL Plan Management Overview
  • SQL Plan Baseline Architecture
  • Automatic Workload Repository Baselines
  • Performance Monitoring and Baselines
  • ADDM Enhancements
  • Automatic Memory Management
  • Database Replay

3. Backup and Recovery Enhancements 

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

4. Flashback and LogMiner Enhancements

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

5. Diagnostic Enhancements

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

6. Security Enhancements

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

7. Storage Enhancements

  • Partitioning Enhancements
  • Automatic Storage Management New Features and Enhancements

8. 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

9. 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
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.