Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







Upgrading to Oracle11g Training

© 2007-2016 by Burleson Corporation


This 11g upgrade training course course is taught at your Company site with up to 20 students. 

Click here for on-site upgrade to 11g training course prices

Don't forget supplemental 11g mentoring


Key Features

* Learn the most important 11g new features and when to use them.

* Understand how to leverage the automatic DBA features.

* See how the Automated Workload Repository (AWR) places important tuning information at your fingertips.

* Use the Automated Session History (ASH) tables to quickly find performance bottlenecks.

* Understand how to use the Automatic Database Diagnostic Monitor (ADDM).

* Learn how to implement the SQLTuning and SQLAccess advisor tools.




Course Description

Unlike some mediocre Oracle 11g upgrade training, this course examines all Oracle11g new features with an eye on those features that are the most important to Upgrading to Oracle11g.

This Oracle 11g upgrade training is special because this course is taught by a veteran Oracle Certified DBA with years of full-time experience.

Book Required

    Oracle Database 11g New Features 

Get started fast with Oracle11g enhancements

John Garmany, Steve Karam, Lutz Hartmann, V. J. Jain, Brian Carr

ISBN 978-0-9797951-0-7


This upgrading to 11g training course is designed for practicing Oracle professionals who have basic experience with Oracle. Prior experience with Oracle is not required, but experience using Oracle database is highly desirable.


Curriculum Design

This upgrading to Oracle 11g training class was designed by Donald K. Burleson, an acknowledged leader in Oracle database administration.  Author of more than 30 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning.  Burleson also served as the Editor for the premier book Oracle 11g New Features for the DBA by Rampant TechPress.  Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle new features training.

Course Duration

This is an intensive 2-day Oracle 11g Upgrade overview.  This course is a comprehensive overview of Oracle11g, taught by a leading Oracle11g trainers. 

Upgrading to 11g Training  Course
2-Day Syllabus

11g upgrade training - Copyright © 2016 by Donald K. Burleson

Oracle 11g Certified Professional

New Features for Database Creation and Deletion
  • SYSAUX Tablespace
  • Automated Storage Management Configuration
  • Automated RAC Services Configuration
  • Simplified Upgrade for RAC and OPS Databases
  • Drop Database  
Database Tuning and Performance Improvements
Database Resource Manager Improvements
  • Database Resource Manager Overview
  • Adaptive Consumer Group Mapping
  • Fixed CPU Quota
  • Integration of Resource Manager and Profiles
Tuning Improvements
  • Buffer Cache Flushing - User Initiated
  • Automated Checkpoint Tuning
  • CPU Costing
  • Dynamic Sampling
Tuning Transaction Recovery
  • Easy Transaction Recovery Monitoring
Oracle Enterprise Manager Changes
  • Overview of the changes
  • SQL Reporting
  • New Performance Overview Charts
Single-Set Aggregates in DML Returning Clause
New and Updated Optimizer Hints
Wait Model Improvements
  • Overview of enhancements
  • Changes and updates
Application Tuning
  • Overview of improvements
  • SQL Access Advisor
  • Materialized View Tuning API - The new TUNE_MVIEW API
New Static Data Dictionary Views
  • Overview
  • List of Views and Explanation
New Dynamic Performance Views
  • Overview
  • List of Views
Static data dictionary views have new columns
Dynamic performance views have new columns
Oracle11g New Features for Tablespace Management
Temporary Tablespace
· Temporary Tablespace Group Overview
· Temporary Tablespace Group Benefits
· Examples
Rename Tablespace
· Tablespace Rename Overview
· Tablespace Rename Benefits
· Examples
Bigfile Tablespace
· Bigfile Tablespace Overview
· Bigfile Tablespace Benefits
· Extended ROWID Format
· Examples
Automated Storage Management (ASM)
· Automated Storage Management Overview
· Automated Storage Management Benefits
· ASM Disk Group
· ASM Disk
· ASM Files
· ASM Instance
New Oracle11g Table and Index Features
Creating a Sorted Hash Cluster
  • Benefits
  • Examples
Partitioning Improvement
  • Overview of Improvements in Partitioning
  • Global Partitioned Indexes - Hash Partitioning
  • Enhancements for Partitioned Index-Organized Tables
   - List Partitioning
   - LOB Support
   - Global Index Maintenance
  • Local Partitioned Indexes Manageability Improvements
  • Enhanced Partition Management in Enterprise Manager
Enhanced Bitmap Index Performance and Space Management
New Oracle11g DML Features: Insert, Update and Delete
Single-Set Aggregates in DML Returning Clause
Upsert through SQL Interrow Calculations
New Oracle11g SELECT features
SQLAccess Advisor
Materialized View Tuning API
Grouped Table Outer Join
Increased Number of Aggregates per Query
SQL Interrow Calculations
Remote Stored Functions in SELECT Statements
Native Net Over Fast Interconnects
Native Net Over TCP/IP
Case-Insensitive and Accent-Insensitive Query and Sort
Enhanced Collections
Enhanced CONNECT BY Support
Oracle Expression Filter
SQL Regular
Row Timestamp
Asynchronous Change Data
Cross-Platform Transportable Tablespaces
Enhanced Table Functions
External Tables Unload
Enhanced MERGE Functionality
New Oracle11g Initialization Parameters
Type of Initialization Parameters
Twenty New Parameters
New Oracle11g Management Features
Database Startup and Shutdown
Overview of enhancements
Database Automated Startup and Shutdown Configuration
Database Install
Simplified Database Install
Improvements in Auditing
Uniform Audit Trail
Extended SQL Support in FGA
Easier Database Registration
Unified User Model
New Oracle11g Network Features
Database Authentication with Standard LDAP Password Verifiers
Single Station Administration for Password Authentication to Oracle Database
SSL Session Renegotiation
Performance Improvements
4096-Bit Key Size Support
Oracle11g Backup and Recovery New Features
Extended Flashback Functions
Flashback Database
Flashback Standby Database
Flashback Re-instantiation
Flashback Drop
Flashback Table
Flashback Row History
Flashback Transaction History
RMAN Enhancements
Automated Channel Failover for Backup and Restore
Automated File Creation During Recovery
Simplified Backups to Disk
Simplified Recovery Manager Cataloging of Backup Files

This is a BC Oracle training course (c) 2016



Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational