Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Oracle 11g > Oracle 11g New Features for Administrators Training

Oracle 11g New Features for Administrators Training

Course#: WA1632

This Oracle 11g courseware training guide book will assist experienced Oracle database administrators to quickly learn the new features and concepts associated with the 11g release of the Oracle database. Based upon this knowledge one will be able to utilize these features and realize the benefits they bring.

Objectives

At the end of this course the students should be able to:

  • Understand the Upgrade Paths to Oracle 11g Release 1
  • Use the SQL Performance Analyzer
  • Record and Replay Workloads
  • Use the Automatic Database Diagnostic Monitor Enhancements
  • Understand the New RMAN capabilities
  • Manage a Flashback Data Archive
  • Use the Data Recovery Advisor
  • Understand and use the New Diagnostic Monitoring Features
  • Identify the Application Development New Features and Enhancements

Audience 

The target audience for this course is database administrators with experience using earlier versions of the Oracle database server who wish to learn about the new and modified features introduced in Oracle 11g. 

Prerequisites

The mandatory prerequisite for this course is experience administering an Oracle database using version Oracle 10g.

Duration

Five days

Outline of WA1632 Oracle 11g New Features for Administrators Training

1. Database installation & upgrade

  • Identify system requirements
  • The optimal flexible architecture (ofa)
  • Oracle_base
  • Oracle_home
  • Configure the installation environment
  • Enterprise edition installation
  • Dbca
  • Database upgrade process
  • Dbua
  • Patching overview

2. Database architecture changes

  • Review the Oracle enterprise architecture
  • More about the Oracle 11g database
  • Undo_management

3. Automatic memory management

  • About memory management
  • Automatic memory management
  • Memory_target
  • Memory_max_target
  • Using em & the memory advisors

4. Diagnosing database problems

  • About the fault diagnosability infrastructure
  • Using the alert log
  • About the trace files
  • Database instance health snapshot
  • Using the support workbench
  • Enable Oracle configuration manager

5. Security enhancements

  • Transparent data encryption
  • Column encryption
  • Tablespace encryption
  • Data pump encryption
  • Backup set encryption
  • Enhanced default security settings
  • Enhanced security options

6. Oracle securefiles

  • Lob concepts & terminology
  • Basicfiles lob
  • Alter table
  • Securefiles lobs
  • Migrating basicfiles to securefiles
  • Monitoring securefiles performance

7. Miscellaneous new features

  • Locking enhancements
  • Automatic maintenance tasks
  • Compression
  • Asm enhancements
  • Asm_preferred_read_failure_groups
  • Compatible.asm and compatible.rdbms
  • Disk_repair_time

8. Oracle flashback technology

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

9. Flashback database

  • About flashback database
  • Configuring the flash recovery area
  • Performing database flashback
  • Monitoring flashback performance
  • Flashback database considerations
  • Configure flashback data archive

10. Rman enhancements

  • Virtual private catalogs
  • Building dynamic scripts
  • Backup optimization
  • Enhancing parallelism with section sizes
  • Archival backups

11. Database duplication & cloning

  • Why perform database duplication?
  • Rman duplicate database
  • Rman duplicate
  • Database cloning

12. Recovery with data recovery advisor

  • Detecting corruption
  • Db_block_checking
  • Db_block_checksum
  • Db_lost_write_protect
  • Db_ultra_safe
  • Recovery using the data recovery advisor

13. Change management

  • Understanding the application architecture
  • Systems infrastructure changes
  • Change management lifecycle

14. Workload capture

  • Preparing the capture database
  • Workload capture using the em wizard
  • Workload capture using the api

15. Configure the replay database

  • Requirements of a replay database
  • Rman duplicate

16. Database replay

  • Preprocess captured workload
  • Replay prerequisites
  • Replay workload
  • Monitor the replay operation

17. Replay analysis

  • Launch replay analysis
  • Conduct configuration change analysis
  • Use the PL/SQL api

18. SQL performance analyzer

  • About SQL performance analysis
  • Managing SQL tuning sets
  • SQL performance analyzer tasks
  • SQL performance analysis

 

We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.