Oracle 11g New Features 9i DBAs

Course code: O1109

3 days £1,380.00

iTrain's Oracle 11g New Features 9i DBA's training course is aimed at existing Oracle DBA's 8i,9i and 10g of the Oracle databases will explore both the migration path and new features of Oracle 11g (R1 or R2).

Course content >

Who Should Attend?

  • Oracle 9i DBA's


Course Reviews

Course Contents

Oracle 11g New Features 9i DBAs training course provides a hands on environment to practice both the new features and key enhancements in Oracle 11g and learn best practise in an upgrade path. For those coming from versions of the database prior to 10g the enhancements are numerous and far reaching.

This unique Oracle 11g New Features for 9i DBAs course objectively assesses this new functionality providing attendees not only with hands on experience to undertake the migration themselves, but also an opportunity to discuss the issues with our experienced team who will provide crucial tips and techniques to ensure the full benefits of Oracle 11g are harnessed and the migration route, tested and robust.

Oracle 11g New Features 9i DBAs 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 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.
Contact us for more information