Oracle 11g New Features Training

This course is taught at your Company site with up to 20 students.

Click here for on-site course prices

Optional supplemental mentoring

* Learn the most important Oracle 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.

Unlike the generic Oracle11g new features training available elsewhere, this course examines all 11g new features with a deep focus on those features that are the most important to 11g availability, performance tuning and development.

What makes this hands-on 11g new features training particularly unique is that it is taught by a working Oracle Certified DBA with more than 20 years of full-time experience.

Oracle Database 11g New Features
Oracle 11g Reference for Advanced Tuning & Administration

This 11g new features 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.

This 11g new features training course was designed by Donald K. Burleson, an acknowledged leader in Oracle database administration. This is an intensive 3-day or 4-day hands-on 11g new features overview. This course is a comprehensive overview of 11g, taught by a leading 11g trainers. The 4-day version of this course explores more robust 11g SQL new features in Virtual Spreadsheets and regular expression syntax.

Oracle 11g New Features Training
3-Day Syllabus

DAY 1

Oracle 11g DBA new features

Interval partitioning for tables

New load balancing utilities

Web server load balancing

RAC instance load balancing

Automated Storage Load balancing

Data Guard Load Balancing

Listener Load Balancing

New table Data Type "simple_integer"

Improved table/index compression

Faster DML triggers

Improved NFS data file management

Server side connection pooling

RMAN UNDO bypass

Capture/replay database workloads

Scalability Enhancements

Scalable execution

Virtual columns

"super" object-oriented DDL keyword

Oracle 11g XML data storage

Data Guard supports "Flashback Standby".

New Trigger features

Partitioning by logical object and automated partition creation.

LOB's - New high-performance LOB features.

Automatic Diagnostic Repository (ADR)

Incident Packaging Service (IPS)

Feature Based Patching

New Oracle11g Advisors

Enhanced Read only tables -
Table trigger firing order

DAY 2

Oracle11g High Availability & RAC new features

Oracle 11g RAC parallel upgrades

Oracle RAC load balancing advisor

ADDM for RAC

Optimized RAC cache fusion protocols

Oracle 11g RAC Grid provisioning

Hot patching

Standby snapshot

Quick Fault Resolution

OEM Oracle 11g new features:

Interfaces to Applications

OEM Easy de-install

Database repair wizard

Better OEM Grid tools

Oracle 11g language & PL/SQL New Features

PHP - Improved PHP driver for Oracle.

PL/SQL "continue" keyword

Disabled state for PL/SQL

Improved native Java & PL/SQL compilers.

Easy PL/SQL compiling

Oracle 11g XML Enhancements

Improved PL/SQL stored procedure invalidation mechanism

Scalable PL/SQL and Java

Improved sequence management

Intra-unit inlining

Enhanced PL/SQL warnings

Named notation

DAY 3

Oracle 11g SQL New Features

The /*+result_cache*/ SQL hint

XML SQL queries

SQL Replay

Improved optimizer statistics collection speed

SQL execution Plan Management

Dynamic SQL

Fully Automatic SQL Tuning

Improved SQL Access Advisor

Oracle 11g Performance new features:

Automatic Memory Tuning

Resource Manager

ADDM for RAC

Faster sorting

AWR Baselines

Adaptive Metric Baselines

Oracle 11g security & auditing new features

Enhanced Passwords

Oracle SecureFiles

Oracle 11g audit vault

Proxy connect for SQL*Plus

FGAC for UTL_SMTP, UTL_TCP and UTL_HTTP.

Fine Grained Dependency Tracking (FGDT)

Database Replay

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