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