Oracle 11g New Features for Database Administrators

Course code: O1102

2 days £720.00

Existing Oracle DBA's upgrading from Oracle 10g to Oracle 11g (R1 or R2) will explore the new features and enhancement of Oracle 11g on this hands on technical course.

Course content >

Who Should Attend?

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


Course Contents

Oracle 11g (R1 & R2) new features and enhancements are explored during this hands on course. Delegates will learn Oracle 11g features and functionality including improved security, performance and monitoring, diagnostics, database scaling and other new features that will directly impact the use of 11g within their enterprise architecture.

Delegates who are upgrading from versions 9i or 8i are recommended to attend iTrain course; Oracle 11g for 9i Database Administrators Course code: O1109

Delegates who are new to Oracle databases are recommended to attend iTrain course; Oracle 11g Database Administrators Fundamentals I Course code: O1110

Installation and Enhancements

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

Change Mgt 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

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

  • 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

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 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
Contact us for more information