Oracle 11G New Features for Experienced 10G DBAs

Audience

Existing Oracle 10G DBA's needing a thorough understanding of the New Features in Oracle 11G from a DBA viewpoint.

Prerequisites

The course is for experienced Oracle Version 10.2 DBAs.

Duration

2 days. Hands on.

Course Objectives

This course is designed to bring existing R10.2 DBAs up-to-date with the new features in the 11g release, covering the following areas: 1) 11g DBA database server features 2) 11g Enterprise Manager new features 3) 11g RMAN new features The course addresses database server issues that all DBAs will need to be aware of. As a product, Oracle is ever expanding its horizons to a degree that now encompasses a significant proportion of the datacentre skills requirement. There is no longer time for an individual to learn Oracle offerings in their entirety. In response, many data centres have DBAs specialising in particular areas of Oracle DBA and we have adjusted our course breakdown to reflect this. The “11G new features for DBAs” course is a good introduction that will make all DBAs aware of platform advancements in the new release.

Course Content

Changes to the database server
Parameters, OFA changes, New admin subdirectories, Alert log changes, Table-level control of CBO statistics

Database Replay
Architecture, Capture, AWR, Replay Analysis

SQL Performance Analyzer
SPA Architecture, What to change ?, SPA package, SQL Performance analyzer workflow, Creating a SQL Tuning Set, Creating a SQL performance analyzer task, Reporting

Transaction management
LogMiner interface in Oracle Enterprise Manager, LogMiner command line interface, Flashback Data Archive

Table and index partitioning
Extended composite partitioning, Reference partitioning, Interval partitioning, System partitioning, Tablespace transport for a single partition, Virtual column partitioning Partition Advisor, Partition Advisor

Schema management
DDL wait option, Adding columns with a default value, Virtual columns, Invisible indexes, Read only tables

Storage
NFS improvements, Secure Files (Next generation LOBS), Version control - Oracle File Group Repository, Oracle 11g XML data storage

RMAN
Data recovery advisor, Advise failure and repair options, Repair failure preview, Pro-active health checks, Validate database, Enterprise Manager interface to RMAN, Flashback logs, Zlib compression, Parallel backup of the same datafile, Backup committed undo, Virtual private catalog, Merging catalogs