Database 11g: New Features

Scheduled Dates Locations filtered. Show all UK course locations.

Course Overview

This course is designed to introduce the new features and enhancements in Oracle11g database to existing DBAs and those familiar with previous versions of Oracle's family of RDBMS products (7, 8, 8i, 9i, 10g).

The course fulfils the need of DBAs to remain up to date with new 11g development as well as considering the impact/opportunities available through the implementation of Oracle 11g database.

Audience

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

Prerequisites

• PC Fundamentals
• Programming Experience
• Working Knowledge of SQL

Course Outline

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

Database 11g: New Features / O1112