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 Database 11g R1 and R2 - New Features For Administrators Training

Oracle Database 11g R1 and R2 - New Features For Administrators Training

Course#: WA1978

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

The objective of this training course is to assist experienced Oracle database administrators to understand the concepts and implement the new features and associated with the R1 and R2 releases of the Oracle 11g database. Based upon this knowledge one will be able to utilize these features and realize the benefits they offer. Among the specific subjects we will consider are:

  • Discuss changes, enhancements and new features within the database architecture, the database parameters and the utilities and facilities used by administrators.
  • The Fault Diagnosability Infrastructure now included within the database and the first-failure data capture capabilities which enhance problem troubleshooting, diagnosis and resolution. Components include the Health Monitor, Support Workbench and Incident Packaging subsystem.
  • Security enhancements include encryption of data, database security attack countermeasures, enhanced default security settings, and the SecureFiles storage mechanism.
  • Backup and recovery enhancements provided through the RMAN framework.
  • Duplicating and cloning databases for the creation of test platforms, standby database installations and application workload replay.
  • Guided recovery of database failures and corruption using the Data Recovery Advisor.
  • Automatic Storage Management (ASM) enhancements and other storage improvements including advanced compression techniques and algorithms.
  • Consider both the challenge and the necessity of changes to the systems infrastructure and how these can disrupt production applications.
  • Review the goals of change management, change assurance and how these are implemented with Real Application Testing technology available with the Oracle 11g database.
  • Learn how to perform the capture of a production database workload while not interfering with the applications or users involved.
  • Learn how to replay the production workload on a test database configuration, providing a real-world test of how an actual application will function in an envisioned database configuration.
  • Learn how to 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 to assess whether the application performance will progress or regress as a result of the proposed change.
  • Use the SQL Performance Analyzer tool to measure progression or regression of individual SQL statements under a proposed database configuration, providing a detailed level of change assurance before the change ever occurs.

Audience

The target audience is the following professionals with experience using earlier versions of the Oracle database server, including:

  • Database administrators
  • Web server administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers
  • Senior application designers and developers

Prerequisites

The mandatory prerequisite for this course is experience administering an Oracle database using version Oracle 10g. Those who lack such experience would be better served by completing the curriculum for new database administrators.

Duration

5 Days

 

Outline of WA1978 Oracle Database 11g R1 and R2 - New Features For Administrators Training

1. 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 & FIXUP UTILITY

2. ENTERPRISE EDITION INSTALLATION

  • START THE INSTALLATION
  • DESKTOP CLASS INSTALLATION 11G R2
  • POST-INSTALLATION CONFIGURATION

3. UPGRADE, DEINSTALLATION & PATCHING

  • DATABASE UPGRADE
  • NETCA
  • DBUA
  • ONLINE PATCHING
  • ORACLE DEINSTALLER

4. STORAGE ENHANCEMENTS

  • ORACLE ADVANCED COMPRESSION
  • HIGH-CAPACITY DISKS & THE REDO FILES
  • COMPRESSED TABLES
  • HYBRID COLUMNAR COMPRESSION
  • DEFERRED SEGMENT CREATION

5. DATABASE ARCHITECTURE CHANGES

  • NEW INSTANCE BACKGROUND PROCESSES
  • ORACLE EXADATA STORAGE SERVER
  • EDITIONS & ONLINE REDEFINITION
  • MISCELLANEOUS PARAMETER CHANGES
  • UNDO_MANAGEMENT

6. AUTOMATIC MEMORY MANAGEMENT

  • ABOUT MEMORY MANAGEMENT
  • AUTOMATIC MEMORY MANAGEMENT
  • MEMORY_TARGET
  • MEMORY_MAX_TARGET
  • USING EM & THE MEMORY ADVISORS
  • THE DATABASE SMART FLASH CACHE

7. 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 & MONITORING RESULT CACHE

8. Using V$RESULT_CACHE_STATISTICS

  • V$RESULT_CACHE_MEMORY
  • V$RESULT_CACHE_OBJECTS
  • V$RESULT_CACHE_DEPENDENCY

9. ENABLING TRANSPARENT DATA ENCRYPTION

  • TRANSPARENT DATA ENCRYPTION
  • MANAGING TDE
  • IMPLEMENTING COLUMN ENCRYPTION

10.ORACLE SECUREFILES

  • LOB CONCEPTS & TERMINOLOGY
  • BASICFILES LOB
  • ALTER TABLE
  • SECUREFILES LOBS
  • Using EM
  • MONITORING SECUREFILES PERFORMANCE
  • MIGRATING BASICFILES TO SECUREFILES

11.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

12. 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

13. MISCELLANEOUS NEW FEATURES

  • LOCKING ENHANCEMENTS
  • DDL_LOCK_TIMEOUT Parameter
  • INVISIBLE INDEXES
  • AUTOMATIC MAINTENANCE TASKS


14. 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

15. AUTOMATIC STORAGE MANAGEMENT

  • ADMINISTERING THE ASM INSTANCE
  • ASM MIGRATION USING EM
  • ORACLE 11G ASM ENHANCEMENTS

16. COMPATIBLE.ASM and COMPATIBLE.RDBMS

  • DISK_REPAIR_TIME
  • ASM_PREFERRED_READ_FAILURE_GROUPS
  • ADMINISTRATION USING EM

17. 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()

18. FLASHBACK DATABASE

  • CONFIGURING THE FLASH RECOVERY AREA
  • PERFORMING DATABASE FLASHBACK
  • MONITORING FLASHBACK PERFORMANCE
  • FLASHBACK DATABASE CONSIDERATIONS
  • CONFIGURE FLASHBACK DATA ARCHIVE

19. RMAN ENHANCEMENTS

  • VIRTUAL PRIVATE CATALOGS
  • Manage VPC Rights
  • Manage A VPC
  • BUILDING DYNAMIC SCRIPTS
  • BACKUP OPTIMIZATION
  • ENHANCED PARALLELISM & SECTION SIZES
  • ARCHIVAL BACKUPS

20. DATABASE DUPLICATION & CLONING

  • WHY PERFORM DATABASE DUPLICATION?
  • RMAN DUPLICATE DATABASE
  • RMAN DUPLICATE
  • DATABASE CLONING

21. 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
  • RMAN Interface

22. CHANGE MANAGEMENT

  • UNDERSTANDING THE APPLICATION ARCHITECTURE
  • SYSTEMS INFRASTRUCTURE CHANGES
  • CHANGE MANAGEMENT LIFECYCLE

23. WORKLOAD CAPTURE

  • PREPARING THE CAPTURE DATABASE
  • WORKLOAD CAPTURE USING THE EM WIZARD
  • WORKLOAD CAPTURE USING THE API

24. CONFIGURE THE REPLAY DATABASE

  • REQUIREMENTS OF A REPLAY DATABASE
  • RMAN DUPLICATE

25. DATABASE REPLAY

  • PREPROCESS CAPTURED WORKLOAD
  • REPLAY PREREQUISITES
  • REPLAY WORKLOAD
  • MONITOR THE REPLAY OPERATION

26. REPLAY ANALYSIS

  • LAUNCH REPLAY ANALYSIS
  • CONDUCT CONFIGURATION CHANGE ANALYSIS
  • USE THE PL/SQL API

27. 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
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.