Back to Search Results

Training Course Summary:

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.

Pre-Requisites:

PC Fundamentals
Programming Experience
Working Knowledge of SQL

Who Should Attend:

Database Administrators
Support Engineer
Data Warehouse Administrator
Technical Consultant

Training Course Overview/Content:

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
back to top
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
back to top
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
back to top
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
back to top
Intelligent Infrastructure
Automatic Workload Repository Baselines
Performance Monitoring and Baselines
Automated Maintenance Tasks
Resource Manager: New EM Interface
back to top
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
back to top
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
back to top
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
back to top
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