Course Details
  
Introduction

Learn To


Oracle Database 11g: New Features for Administrators  
Course ORC038: Five days; Instructor-led

Introduction

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.

This course counts towards the Hands-on course requirement for the following certifications:

Oracle Database 9i Administrator Certification

Oracle Database 10g Administrator Certification

Oracle Database 11g Administrator Certification

Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-ROM and Knowledge Center courses DO NOT meet the Hands-on Requirement.

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

Data Warehouse Administrator

Database Administrators

Support Engineer

Technical Consultant



Prerequisites

Required Prerequisites
Strong Oracle Database 10g concepts

Suggested Prerequisites
Oracle Database 10g: New Features for Administrators Release 2
Oracle Database 10g: Administration Workshop II Release 2

Course Objectives
  • Use the SQL Performance Analyzer
  • Upgrade your database to 11g Release 1
  • Record and reply 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

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 Compatibililty

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 Managebility 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 Archiecture: 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 Exisiting 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