Training

Home > Training > Oracle Database > Oracle 11g >

WA1632 Oracle 11g New Features for Administrators Training and Courseware

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

Course Outline

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

Buy on-site and customized class

Attend a public class