BC Upgrading to Oracle 11g Class
May 8-16, 2015

The world's best Oracle training comes from practicing Oracle consultants, real Oracle experts and authors who combine years of experience with outstanding communications skills.  The problem is that the top Oracle experts are busy working with mission critical databases and rarely do public training. 

About the Oracle 11g training

The first day of class begins in Port Canaveral on May 8, 2015 and concludes on May 16, 2015.   To book your seat, simply call 800-766-1884.  This advanced Oracle DBA training features one-on-one personal interaction and this class is created specifically for the needs of DBAs and technical managers:

Upgrading to Oracle11g

Copyright � 2007-2010 by Burleson Consulting

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
 
 
Improved Features: MERGE, EXTERNAL TABLES, MINSERT
 
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
            CREATE_STORED_OUTLINES
            DB_ALLOWED_LOGIN_VERSION
            DB_FLASHBACK_RETENTION_TARGET
            DB_RECOVERY_FILE_DEST
            DB_RECOVERY_FILE_DEST_SIZE
           DDL_WAIT_FOR_LICKS
            INSTANCE_TYPE
            LDAP_DIRECTORY_ACCESS
            LOG_ARCHIVE_CONFIG
           OSM_DISK_REPARIR_TIME
           OSM_DISKGROUPS
           OSM_DISKSTRING
           OSM_POWER_LIMIT
            PLSQL_OPTIMIZE_LEVEL
            PLSQL_WARNINGS
            RESUMABLE_TIMEOUT
            SKIP_UNUSABLE_INDESES
             SMTP_OUT_SERVER
             SP_NAME
            STREAMS_POOL_SIZE
 
 
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
 
 
 

About your instructors

Only once per year, Burleson Consulting offers a public training class, a rare opportunity to learn the secrets of Oracle from some of the world's most highly regarded Oracle experts and authors, people who have managed some of the world's largest and complex databases.

Donald K. Burleson is one of the world's best known Oracle experts and authors.  A retired Adjunct Professor Emeritus, Burleson has more than 20 years of full-time DBA experience, authored 32 Oracle database books, written over 100 Oracle articles, and serves as Editor-in-Chief of Rampant TechPress

BC has some of the top Oracle experts in the world, and this is a not-to-miss class with expert advise for working DBA professionals.  Unlike traditional Oracle DBA training, the BC Oracle DBA training is taught by practicing Oracle DBA consultants with decades of hands-on, real-world experience.

The BC Oracle DBA training is better quality training at an even better price.  With course costs of $1,995 (with discounts for multiple attendees) plus travel and expenses, the BC Oracle training is far less expensive than a traditional DBA class, with an unparalleled intimate learning experience.

 

 

 

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 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.