Microsoft training courses, Cisco training courses, Prince2 training courses, ISEB training courses with locations nationwide
Call now to speak to an experienced Training Advisor
 
     
 
Home
  
How it works
  
About the quality of your course
 
Managed services
  
Partner CourseMonster
  
 
 
Thousands of Microsoft, ISEB, ITIL, Cisco and Prince2 Training Courses and more
  
 
Browse Oracle Training Courses

Database 11g: New Features for 10g DBAs

Course Code: O11G10      Days: 5
Show all Oracle Courses
Scheduled Dates (sort by: location | date)
Request availability or book by selecting a date:
Central London
City
London (EC1) 24/11/08 £ 1,795
London (EC1) 09/02/09 £ 1,795
London (EC1) 30/03/09 £ 1,795
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.

Course Overview

This course gives students the opportunity to learn about-and practice with the new change management features and other key enhancements in Oracle Database 11g Release 1. Students examine the benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance, strengthening security, and several other areas that concern database administrators. In addition, the hands-on practice sessions help reinforce students understanding of these new capabilities in Oracle Database 11g Release 1.

Delegates will learn to:

  • Implement manageability features to simplify database management
  • Utilize database advisors to provide proactive database monitoring
  • Increase data availability by using improved ASM, RMAN, and Flashback features.
  • Use change management features to master database changes

Audience

  • Database Administrators
  • Support Engineer
  • Data Warehouse Administrator
  • Technical Consultant

Skills Gained

Delegates will be able to:

  • Use the SQL Performance Analyzer
  • Upgrade your database to 11g Release 1
  • Record and replay workloads
  • Use the automatic database diagnostic monitor
  • Explore advanced RMAN capabilities
  • Manage a flashback data archive
  • Use the data recovery advisor
  • Setup and use ASM

Prerequisites

  • Strong Oracle Database 10g concepts
  • Oracle Database 10g: New Features for Administrators Release 2
  • Oracle Database 10g: Administration Workshop II Release 2

Course Outline

Installation and Upgrade Enhancements

  • Oracle Database 11g Installation: Changes
  • Oracle Database 11g: Software Installation
  • Oracle Database Upgrade Enhancements
  • Upgrade Performance Enhancement
  • Upgrade Process
  • Oracle Database 11g Release 1: Upgrade Paths
  • Database Upgrade Assistant (DBUA)
  • Hot Patching: Overview

Storage Enhancements

  • ASM Fast Mirror Resync: Overview
  • ASM Preferred Mirror Read: Overview
  • ASM Scalability and Performance Enhancements
  • ASM Scalability in Oracle Database 11g
  • ASM Disk Group Compatibility
  • ASMCMD Extensions

Change Management Unit Overview

  • Change Management in Oracle Database 11g
  • Challenges Faced by DBAs When Performing Changes
  • Lifecycle of Change Management
  • Setting Up a Test Environment by Using the Snapshot Standby Database
  • SQL Performance Analyzer: Overview
  • Capturing the SQL Workload
  • SQL Performance Analyzer: Data Dictionary Views

SQL Plan Management

  • SQL Plan Management: Overview
  • SQL Plan Baseline: Architecture
  • Evolving SQL Plan Baselines
  • SQL Plan Selection
  • Possible SQL Plan Manageability Scenarios
  • SQL Performance Analyzer and SQL Plan Baseline Scenario
  • Loading a SQL Plan Baseline Automatically
  • Purging SQL Management Base Policy

Database Replay

  • System Architecture: Capture
  • System Architecture: Processing the Workload
  • System Architecture: Replay
  • Pre-Change Production System
  • Supported Workloads
  • Database Replay Workflow in Enterprise Manager
  • Using the Capture Wizard
  • Packages and Procedures

Automatic SQL Tuning

  • Automatic SQL Tuning in Oracle Database 11g
  • Selecting Potential SQL Statements for Tuning
  • Maintenance Window Timeline
  • Automatic Tuning Process
  • DBA Controls
  • Automatic SQL Tuning Task
  • Automatic SQL Tuning: Fine Tune
  • Automatic SQL Tuning Considerations

Intelligent Infrastructure Enhancements

  • Automatic Workload Repository Baselines
  • Performance Monitoring and Baselines
  • Automated Maintenance Tasks
  • Resource Manager: New EM Interface

Performance Enhancements

  • ADDM Enhancements in Oracle Database 11g
  • Oracle Database 11g: Automatic Database Diagnostic Monitor for RAC
  • New ADDM Views
  • Automatic Memory Management: Overview
  • Oracle Database 11g Memory Parameters
  • Automatic Memory Parameter Dependency
  • Monitoring Automatic Memory Management

Partitioning and Storage-Related Enhancements

  • Oracle Partitioning
  • Partitioning Enhancements
  • Interval Partitioning
  • System Partitioning
  • Virtual Column-Based Partitioning
  • Reference Partitioning
  • Table Compression: Overview
  • SQL Access Advisor: Overview
  • Using RMAN Enhancements
  • RMAN: New Features
  • Optimized Backups
  • Parallel Backup and Restore for Very Large Files

Using RMAN Multisection Backups

  • Duplicating a Database
  • Managing Recovery Catalogs
  • Creating and Using Virtual Private Catalogs
  • Using RMAN Virtual Private Catalogs

Using Flashback and LogMiner

  • New and Enhanced Features for Flashback and LogMiner
  • Flashback Data Archive Overview: "Oracle Total Recall"
  • Flashback Data Archive: Architecture
  • Flashback Data Archive: Workflow
  • Guidelines and Usage Tips
  • Flashback Transaction Backout
  • Flashback Transaction Wizard
  • Using LogMiner

Diagnosability Enhancements

  • Oracle Database 11g R1 Fault Management
  • Ease Diagnosis: Automatic Diagnostic Workflow
  • Automatic Diagnostic Repository
  • Location for Diagnostic Traces
  • Incident Packaging Service (IPS)
  • EM Support Workbench: Overview
  • Health Monitor: Overview
  • Data Recovery Advisor

Using the Data Recovery Advisor

  • Repairing Data Failures
  • Data Recovery Advisor
  • Data Recovery Advisor RMAN Command-Line Interface
  • Best Practice: Proactive Checks
  • Setting Parameters to Detect Corruption

Security: New Features

  • Secure Password Support
  • Automatic Secure Configuration
  • Managing Default Audits
  • Setting Database Administrator Authentication
  • Transparent Data Encryption
  • Hardware Security Module
  • Using RMAN Security Enhancements

Oracle SecureFiles

  • Managing Enterprise Information
  • Problems with Existing LOB Implementation
  • Oracle SecureFiles
  • Shared I/O Pool
  • Altering SecureFiles
  • Accessing SecureFiles Metadata
  • Migrating to SecureFiles
  • SecureFiles Monitoring

Miscellaneous New Features

  • Foreground Statistics
  • Online Redefinition Enhancements
  • Minimizing Dependent Recompilations
  • Locking Enhancements
  • Invisible Index: Overview
  • SQL Query Result Cache: Overview
  • Adaptive Cursor Sharing: Overview
  • Temporary Tablespace Shrink

Follow On Courses

  • Oracle Database 11g: RAC Administration
  • Oracle Database 11g: Implement Streams
  • Oracle Database 11g: Performance Tuning
  • Oracle Database 11g: Data Guard Administration
  • Oracle Database 11g: SQL Tuning Workshop


How to make a booking for the O11G10 course
 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership