Oracle 11g New Features Training

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

Click here for on-site 11g course prices

Optional 11g 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 Oracle 11g 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 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 11g New Features  Get started fast with Oracle11g enhancements Steve Karam, Brian Carr, et al. ISBN = 0-9797951-0-9

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.
 

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
 

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

Interfaces to Applications

OEM Easy de-install

Database repair wizard

Better OEM Grid tools

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

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

Automatic Memory Tuning

Resource Manager

ADDM for RAC

Faster sorting

AWR Baselines

Adaptive Metric Baselines

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