Back to Search Results

Training Course Summary:

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

This course is ideal for those that need a high level technical review of the new features offered in the latest release of the Oracle database.

Pre-Requisites:

PC Fundamentals
Programming Experience
Working Knowledge of SQL

Who Should Attend:

Database Administrators
Support Engineer
Data Warehouse Administrator
Technical Consultant
Project Managers

Training Course Overview/Content:

Introduction
Oracle Database Innovation
Enterprise Grid Computing
Oracle Database 11g: Focus Areas
Management Automation
Oracle Database 11g: New Features Overview Seminar
Oracle Database 11g: Change Management Overview Seminar
back to top
Managing Storage
Automatic Storage Management (ASM) Enhancements
ASM Fast Mirror Resync: Overview
Setting Up ASM Fast Mirror Resync
ASM Preferred Mirror Read: Setup
ASM Scalability & Performance Enhancements
SYSASM & ASM Disk
ASMCMD Extensions
SecureFiles: Overview
back to top
Data Recov. Advisor, Flashback
Repairing Data Failures
Data Recovery Advisor
Listing Data Failures
Advising on Repair
Setting Corruption-Detection Parameters.
Flashback Data Archive
Creating a Flashback Data Archive: Example.
Using Flashback Data Archive: Examples
back to top
RMAN, Data Guard Enhancements
RMAN Enhancements in Oracle Database 11g
Duplicating a Database
Active Database Duplication: Selecting the Source
RMAN DUPLICATE Command
Creating a Standby Database with the DUPLICATE Command
Parallel Backup and Restore for Very Large Files
Using RMAN Multisection Backups
Archival Database Backup
back to top
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
back to top
Intelligent Infrastructure
Automatic SQL Tuning in Oracle Database 11g
Moving Window Baseline
Baseline Templates
Generating Baseline for a Single Time Period
Using EM to Quickly Configure Adaptive Thresholds
Changes to Procedures and Views
Automated Maintenance Tasks
Default Maintenance Resource Manager Plan
back to top
Datawarehousing Enhancements
SQL Access Advisor in Oracle Database 11g
Oracle Partitioning
Partitioning Enhancements
Interval Partitioning
Interval Partitioning: Example
Moving the Transition Point
System Partitioning
Composite Partitioning Enhancements
back to top
Performance Enhancements
Statistic Preferences: Overview
Partitioned Tables and Incremental Statistics in Oracle Database 11g
Hash-Based Sampling for Column Statistics
Multicolumn Statistics: Overview
Expression Statistics: Overview
Deferred Statistics Publishing: Overview
Query Result Cache
Setting Up the Query Result Cache