New Oracle 11g R2 Features for Administrators

ORC-246 (5 Days)

Oracle 11g R2 Administration training Overview

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.

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

40%

Lecture/Demo

60%

Lab

Course Number:

ORC-246

Duration:

5 Days

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

A complete installation of Oracle Enterprise Edition 11g R2
Oracle SQL Developer

Alabama

Huntsville

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

Ceder Rapids

Des Moines

Kansas

Wichita

Kentucky

Lexington

Louisville

Louisiana

Banton Rouge

New 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

Las Vegas

New Jersey

Princeton

New Mexico

Albuquerque

New York

Buffalo

Albany

White Plains

New 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

Alberta

Edmonton

Calgary

British Columbia

Vancouver

Nova Scotia

Halifax

Ontario

Ottawa

Toronto

Quebec

Montreal

Puerto Rico

San Juan