Oracle 11g New Features for Administrators Training

5 days


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.


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.

Skills Gained

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


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

Five days

Course Outline

Outline of 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
  • of timestamp
  • 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

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

Related Courses


Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.