Oracle Database 11g: New Features for Administrators

Trainingsziel

Dieser Kurs vermittelt folgende Kenntnisse und Fähigkeiten:

Dieser Kurs zeigt die neuen Change-Management Funktionen innerhalb von Oracle DB 11g.

• 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

Teilnehmerkreis

Data Warehouse-Administrator

Technischer Berater

Datenbankadministratoren

Voraussetzungen

Um diesen Kurs erfolgreich absolvieren zu können, sollten Sie über folgende Vorkenntnisse verfügen:

• (AOR-2101) Oracle Database 10g: Neue Features fur Administratoren



• (AOR-2103) Oracle Database 10g: Administration Workshop II Release 2

Im Vorfeld

AOR-2101: Oracle Database 10g: New Features für Administratoren Rel. 2

AOR-2103: Oracle Database 10g: Administration Workshop II Rel. 2

Im Anschluss

AOR-1009: Oracle Database 11g: SQL Tuning Workshop

Überblick über den Inhalt des Trainings

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