Oracle 11g for 9i DBA's (O1109) Training Course

Training Course Objectives

This course is intended to familiarise the Oracle 9i DBA with new features of both 10g and 11g database, perhaps as part of a planned upgrade from Oracle 9i to Oracle 11g database.

Who Should Attend

• Oracle 9i DBA's

Training Course Prerequisites

• PC Fundamentals
• Programming Experience
• Oracle 9i DBA Experience

Training Course Duration

3 Days

Training Course Contents

Diagnostic Enhancements

• Fault Management
• Feature Based Patching
• The Alert Log
• Dump Files
• Support Workbench
• Health Checks

Shared Memory Management

• Manual Memory Allocation
• Setting up Automatic Shared Memory Management
• Non-dynamic SGA Buffers
• Tablespace Management
• Default Permanent Tablespace
• Rename Tablespace
• SYSAUX Tablespace

Space Management

• Segment Advisor
• Improved Segment Size Estimation.
• Shrinking Segments
• Undo Advisor
• Automatic Undo Retention Tuning.

Export & Import

• Export, Import and Data Pump
• Directories and Files
• Example of a Data Pump Job
• Data Pump Features
• Data Pump API
• External Tables
• Cross-Platform Transportable Tablespaces.

Automated Storage Management

• ASM Instances and Database Instances.
• ASM Disk Groups
• ASM Files
• Data dictionary Views

Automatic Workload Repository

• Automatic Statistics Collection
• Baselines.
• Workload Repository Views
• AWR Reporting.
• Feature Usage Metrics
• Active Session History (ASH).

ADDM

• ADDM Reporting
• Server Alerts
• Related Views
• Automatic SQL Tuning in Oracle Database 11g.
• SQL Tuning Advisor
• SQL Tuning Advisor Features

Miscellaneous Tuning Features

• Buffer cache flushing
• Optimizer Changes
• Gathering Data Dictionary Statistics.

RMAN Enhancements

• Flash Recovery Area
• Fast Incremental Backups
• Using Image Copies with Incremental Backups.
• Image Copies and the BACKUP Command.
• Catalog Maintenance
• Automatic Instance Creation for RMAN TSPITR.
• Global Stored Scripts
• Backupset Compression
• Restore Preview
• Limiting Backup Duration
• More Robust Backup and Restore.

Security: New Features

• Security Enhancements
• Secure Default Configuration
• Enabling the Built-in Password Complexity Checker.
• Managing Default Audits
• Privileges Audited By Default
• Adjusting Security Settings
• Setting Security Parameters
• Setting Database Administrator Authentication.

Intelligent Infrastructure

• Moving Window Baseline
• Baseline Templates
• Generating Baseline for a Single Time Period.
• Automatic Workload Repository Baselines.
• Performance Monitoring and Baselines.
• Automated Maintenance Tasks
• Resource Manager: New EM Interface.

Next Available Dates

• 15th Sep 2010  Edinburgh
• 6th Oct 2010  Leeds
• 12th Oct 2010  London
• 27th Oct 2010  Swindon