0845 450 6120

Oracle 11g New Features 9i DBAs

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).

We don't currently have any courses listed for Oracle 11g New Features 9i DBAs, would you like to view all courses for Oracle?

Learning Objectives

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.

Course Content

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

  • 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.

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Our Customers Include