Accelebrate's Oracle 11g R2 Administration Training: Oracle 11g R2 New Features for Administrators course teaches current Oracle systems administrators how to manage the new features of Oracle 11g R2.

Course Number:

ORC-246

Duration:

5 Location and Pricing

Most Accelebrate courses are delivered as private, customized, on-site training at our clients' locations worldwide for groups of 3 or more attendees and are custom tailored to their specific needs. Please visit our client list to see organizations for whom we have delivered private in-house training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote for private training at your site or online, please contact us.

Oracle 11g R2 Administration training Objectives

Understand changes, enhancements and new features within the database architecture
Work with the database parameters and the utilities and facilities used by administrators
Master using the Fault Diagnosability Infrastructure now included within the database
Use the first-failure data capture capabilities which enhance problem troubleshooting, diagnosis and resolution
Use the new Security enhancements
Use the RMAN framework enhancements for Backup and recovery
Duplicate and clone databases for the creation of test platforms, standby database installations and application workload replay
Guide the recovery of database failures and corruption using the Data Recovery Advisor
Use the Automatic Storage Management (ASM) enhancements and other storage improvements
Implement the Real Application Testing technology available with the Oracle 11g R2 database
Perform the capture of a production database workload while not interfering with the applications or users involved.
Replay the production workload on a test database configuration
Configure clients which will simulate the network interaction of real-world users in a test configuration
Perform a detailed analysis of application execution within proposed database configurations
Use the SQL Performance Analyzer tool

Oracle 11g R2 Administration training Outline

Expand All | Collapse All | Printer-Friendly

Configuring The Server For Installation

Identify System Requirements

Optimal Flexible Architecture (Ofa)

Oracle_Base

Oracle_Home

Configure Linux Installation

Oracle_Hostname Environment Variable

Configure Ms Windows Installation

Oracle_Home Variable

Oracle_Hostname Variable

Prerequisite Checks and Fixup Utility

Enterprise Edition Installation

Start The Installation

Desktop Class Installation 11g R2 R2

Post-Installation Configuration

Upgrade, Deinstallation and Patching

Database Upgrade

Netca

Dbua

Online Patching

Oracle Deinstaller

Storage Enhancements

Oracle Advanced Compression

High-Capacity Disks and The Redo Files

Compressed Tables

Hybrid Columnar Compression

Deferred Segment Creation

Database Architecture Changes

New Instance Background Processes

Oracle Exadata Storage Server

Editions and Online Redefinition

Miscellaneous Parameter Changes

Undo_Management

Automatic Memory Management

About Memory Management

Automatic Memory Management

Memory_Target

Memory_Max_Target

Using Em and The Memory Advisors

The Database Smart Flash Cache

Using The Database Result Cache

About The Result Cache

Configuring The Result Cache

Result_Cache_Max_Size

Result_Cache_Mode

Result_Cache_Max_Result

Result_Cache_Remote_Expiration

Using The Result Cache

Relies_On Clause

Managing and Monitoring Result Cache

Using V$Result_Cache_Statistics

V$Result_Cache_Memory

V$Result_Cache_Objects

V$Result_Cache_Dependency

Enabling Transparent Data Encryption

Transparent Data Encryption

Managing Tde

Implementing Column Encryption

Oracle Securefiles

Lob Concepts and Terminology

Basicfiles Lob

Alter Table

Securefiles Lobs

Using Em

Monitoring Securefiles Performance

Migrating Basicfiles To Securefiles

Additional Security Enhancements

Data Pump Encryption

Backup Set Encryption

Em Backup Encryption

Rman Backup Encryption

Decrypt During Recovery

Tablespace Encryption

Sql Create Tablespace With Encryption

Enhanced Default Security Settings

Enhanced Security Options

Diagnosing Database Problems

Fault Diagnosability Infrastructure

Adr Highlights From Em

Using The Alert Log

About The Trace Files

Database Instance Health Snapshot

Using The Support Workbench

Enable Oracle Configuration Manager

Miscellaneous New Features

Locking Enhancements

Ddl_Lock_Timeout Parameter

Invisible Indexes

Automatic Maintenance Tasks

Grid Infrastructure Installation

What Is The Grid Infrastructure?

Identify System Requirements

Managing Linux Devices

Managing Ms Windows Devices

Configure Linux Installation

Grid Infrastructure Installation

Verify The Installation

Subsequent Database Installation

Automatic Storage Management

Administering The Asm Instance

Asm Migration Using Em

Oracle 11g R2 Asm Enhancements

Compatible.Asm And Compatible.Rdbms

Disk_Repair_Time

Asm_Preferred_ Read_Failure_Groups

Administration Using Em

Oracle Flashback Technology

Flashback Query

Select...As Of Timestamp

Select...As Of Scn

Flashback Table

Flashback Drop

Flashback Versions Query

Flashback Transaction Query

Flashback Transaction Backout

Using Dbms_Flashback()

Flashback Database

Configuring The Flash Recovery Area

Performing Database Flashback

Monitoring Flashback Performance

Flashback Database Considerations

Configure Flashback Data Archive

Rman Enhancements

Virtual Private Catalogs

Manage Vpc Rights

Manage A Vpc

Building Dynamic Scripts

Backup Optimization

Enhanced Parallelism and Section Sizes

Archival Backups

Database Duplication and Cloning

Why Perform Database Duplication?

Rman Duplicate Database

Rman Duplicate

Database Cloning

Recovery With Data Recovery Advisor

Detecting Corruption

V$Database_Block_Corruption View

Db_Block_Checking

Db_Block_Checksum

Db_Lost_Write_Protect

Db_Ultra_Safe

Recovery Using Data Recovery Advisor

Change Management

Understanding The Application Architecture

Systems Infrastructure Changes

Change Management Lifecycle

Workload Capture

Preparing The Capture Database

Workload Capture Using The Em Wizard

Workload Capture Using The Api

Configure The Replay Database

Requirements Of A Replay Database

Rman Duplicate

Database Replay

Preprocess Captured Workload

Replay Prerequisites

Replay Workload

Monitor The Replay Operation

Replay Analysis

Launch Replay Analysis

Conduct Configuration Change Analysis

Use The Pl/Sql Api

Sql Performance Analyzer

About Sql Performance Analysis

Managing Sql Tuning Sets

Sql Performance Analyzer Tasks

Sql Performance Analysis

Solutions

Sql Performance Analysis-1

Sql Performance Analysis-2

Sql Performance Analysis-3

Sql Performance Analysis-4

Sql Performance Analysis-5

Sql Performance Analysis-6

Sql Performance Analysis-7

Conclusion

Prerequisites:

Experience administering an earlier version of Oracle is mandatory. If the attendees have not previously administered Oracle, they should take Oracle 11g R2 Administration I training, Oracle 11g R2 Administration II training and Oracle 11g Backup & Recovery training.

Training Materials:

All students receive comprehensive courseware and a related textbook.

Software needed for each student PC:

A complete installation of Oracle Enterprise Edition 11g R2
Oracle SQL Developer
For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor's screen simultaneously with working on their own.

Related Courses:

40%

Lecture/Demo

60%

Lab

Software needed for each student PC:

A complete installation of Oracle Enterprise Edition 11g R2
Oracle SQL Developer
For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor's screen simultaneously with working on their own.

Please see our complete list of
Microsoft Official Courses

Recent Training Locations

United States

Alabama

Hunstville

Montgomery / Birmingham

Alaska

Anchorage

Arizona

Phoenix

Tucson

Arkansas

Fayetteville / Little Rock

California

San Francisco /

Oakland / San Jose

Orange County / Los Angeles

Sacramento

San Diego

Colorado

Denver /

Boulder / Colorado Springs

Connecticut

Hartford

Washington

Florida

Fort Lauderdale / Miami

Jacksonville

Orlando

Saint Petersburg / Tampa

Georgia

Atlanta

Augusta & Savannah

Idaho

Boise

Illinois

Chicago

Indiana

Indianapolis

Iowa

Cedar Rapids / Des Moines

Kansas

Wichita

Kentucky

Lexington / Louisville

Louisiana

Baton Rouge / Orleans

Maine

Portland

Maryland

Annapolis / Baltimore

Hagerstown & Frederick

Massachusetts

Springfield

Boston / Cambridge

Michigan

Ann Arbor / Detroit

Grand Rapids

Minnesota

Saint Paul / Minneapolis

Mississippi

Jackson

Missouri

Kansas City

St. Louis

Nebraska

Lincoln / Omaha

Nevada

Reno and Las Vegas

New Jersey

Princeton

New Mexico

Albuquerque

New York

Buffalo

Albany

White Plains / York City

North Carolina

Charlotte

Durham / Raleigh

Ohio

Canton / Akron

Cincinnati

Cleveland & Columbus

Dayton

Oklahoma

Tulsa / Oklahoma City

Oregon

Portland

Pennsylvania

Pittsburgh

Philadelphia

Rhode Island

Providence

South Carolina

Columbia & Charleston

Spartanburg & Greenville

Tennessee

Memphis / Nashville

Knoxville

Texas

Dallas

El Paso

Houston

San Antonio / Austin

Utah

Salt Lake City

Virginia

Richmond / Alexandria / Arlington

Washington

Tacoma / Seattle

West Virginia

Charleston

Wisconsin

Madison / Milwaukee

Canada

Alberta

Edmonton / Calgary

British Columbia

Vancouver

Nova Scotia

Halifax

Ontario

Ottawa

Toronto

Quebec

Montreal

Puerto Rico

San Juan

ACCELERATED LEARNING, CELEBRATED RESULTS ®

Introduction to Oracle 11g R2 SQL Programming

Beginning Oracle 11g R2 PL / SQL

Advanced Oracle 11g R2 PL / SQL

Oracle 11g R2 Administration I

Oracle 11g R2 Administration II

New Oracle 11g R2 Features for Administrators

Introduction to Oracle 11g R2 Performance Tuning

Introduction to Oracle Application Express 4

Oracle 11g R2 New & Advanced Features For Developers

Oracle 11g R2 RMAN Backup and Recovery

New Oracle 11g R2 Features for Administrators

40%

60%

Course Number:

ORC-246

Duration:

5

Location and Pricing

Oracle 11g R2 Administration training Objectives

Oracle 11g R2 Administration training Outline

Prerequisites:

Training Materials:

Software needed for each student PC:

Related Courses:

40%

60%

Course Number:

ORC-246

Duration:

5 Days

Prerequisites:

Training Materials:

Software needed for each student PC:

Related Courses:

Recent Training Locations

United States

Canada

Puerto Rico

ACCELERATED LEARNING, CELEBRATED RESULTS ®

New Oracle 11g R2 Features for Administrators

40%

60%

Course Number:

ORC-246

Duration:

5

Location and Pricing

Oracle 11g R2 Administration training Objectives

Oracle 11g R2 Administration training Outline

Prerequisites:

Training Materials:

Software needed for each student PC:

Related Courses:

40%

60%

Course Number:

ORC-246

Duration:

5 Days

Prerequisites:

Training Materials:

Software needed for each student PC:

Related Courses:

Contact Us:

Subscribe to our Newsletter:

Recent Training Locations

United States

Canada

Puerto Rico