Your privacy matters: This site uses cookies to analyze site usage and provide social media features. Learn More.

New Oracle 11g R2 Features for Administrators

ORC-246 (5 Days)

Request Pricing

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

Lecture percentage

40%

Lecture/Demo

Lab percentage

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

Contact Us:

Accelebrate’s training classes are available for private groups of 3 or more people at your site or online anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.

For pricing and to learn more, please contact us.

Contact Us Train For Us

Toll-free in US/Canada:
877 849 1850
International:
+1 678 648 3113

Toll-free in US/Canada:
866 566 1228
International:
+1 404 420 2491

925B Peachtree Street, NE
PMB 378
Atlanta, GA 30309-3918
USA

Subscribe to our Newsletter:

Never miss the latest news and information from Accelebrate:

Microsoft Gold Partner

Please see our complete list of
Microsoft Official Courses

Recent Training Locations

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

DC

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

© 2013-2019 Accelebrate, Inc. All Rights Reserved. All trademarks are owned by their respective owners.