Oracle Database 11g: New Features for Oracle 9i DBAs/1Z0_055

Download Course Contents

Oracle Database 11g: New Features for Oracle 9i DBAs Course Overview

Koenig offers a course on Oracle Database 11g: New Features for Oracle 9i DBA.This course introduces students to the new features of Oracle Database 10g and Oracle Database 11g. After completing this course, students will be able to: upgrade an Oracle9i database to Oracle Database 11g. Students will also learn: how to set up and perform typical tasks using the new features available with Oracle Database 10g and Oracle Database 11g including many of the Advisors. This course will train students to use features that increase database availability, simplify overall database management, and improve performance.

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Planning Your Upgrade to Oracle Database 11g
  • Steps to Upgrade to Oracle Database 11g
  • Choosing an Upgrade Method
  • Performing Character Conversion
  • Installing Oracle Database 11g Software
  • Applying Oracle Software Patches
  • Creating a Database
  • Why Use Database Replay?
  • Pre-Change Production System
  • Capture / Replay Considerations
  • Performing Workload Capture
  • Performing Workload Replay
  • Using SQL Performance Analyzer
  • Using Database Replay to test system changes
  • Using SQL Performance Replay to test SQL changes
  • Using DBUA to Upgrade the Database
  • Oracle Database 11g: Upgrade Enhancements
  • Backing Up the Database Before Upgrade
  • Using the Preupgrade Information Tool
  • Using New Postupgrade Status Utility
  • Upgrading Server Manager scripts
  • Performing Additional Upgrade Tasks
  • Using New Features in Your Upgraded Database
  • Executing the Postupgrade Script
  • Upgrading the National Character Set toAL16UTF16
  • Checking for Unusable Function-based Indexes
  • Upgrading the Recovery Catalog
  • Administering the Database Using Enterprise Manager: Overview
  • Using Database Control
  • Granting Database Control Administrative Privileges
  • Using Grid Control to Manage Your Environment
  • Setting Preferred Credentials
  • Oracle Database 11g: Self-Managing Database
  • Automatic Workload Repository
  • Job Scheduler Concepts
  • Server-Generated Alerts
  • Advisor Framework
  • Automatic Database Diagnostic Monitor
  • Configuring Alerts
  • Database Resource Manager: Concepts (auto enabled)
  • Using New Features of Database Resource Manager
  • Exploring Allocation methods
  • Maximum Estimated Execution Time
  • Automatic Consumer Group Switching
  • Using Resource Manager Statistics
  • Scheduler Concepts
  • Using Scheduler Programs
  • Windows and Resources
  • Administering the Scheduler
  • Enabling Automatic Memory Management
  • Modifying Parameters for Automatically Managed Components
  • Modifying Parameters for Manually Sized Components
  • Monitoring Automatic Memory Management
  • Using the SYSAUX Tablespace
  • Specifying a Default User Tablespace
  • Using Oracle Managed Files (OMF
  • Creating Bigfile Tablespaces
  • Using Nonstandard Block Sizes
  • Proactively Monitoring Tablespaces
  • Using the Redo Logfile Sizing Advisor
  • ASM: Key Features and Benefits
  • ASM: General Architecture
  • Accessing an ASM Instance
  • ASM Administration
  • Database Instance Parameter Changes
  • Migrating Your Database to ASM
  • Understanding Automatic Undo Management
  • Specifying the Undo Management Mode
  • Setting the Undo Management Initialization Parameters
  • Using the Undo Advisor
  • Unlocking Default User Accounts
  • Specifying a Common Password for System
  • Securing access by user
  • Using Fine-Grained Auditing
  • Auditing the SYS User
  • Understanding Changes to the Audit Trail
  • Using Automatic Segment-space Management
  • Estimating Table and Index Size Before Creation
  • Granting Object Privileges on Behalf of the Object Owner
  • Performing Online Redefinition of Tables
  • Enabling Data Segment Compression
  • Automatically Collecting Statistics
  • Using the Segment Advisor
  • Using Data Pump to Import and Export Data
  • Managing External Tables
  • Cross-Platform Transportable Tablespaces
  • Using RMAN to Back up the SPFILE
  • Creating Change-aware Incremental Backups
  • Encrypting backups
  • Using backup compression
  • Using RMAN to Perform Recovery: Automatic File Creation During Recovery
  • Performing Trial Recovery
  • Enabling and Performing Flashback Database
  • Using Flashback Query
  • Auditing and Recovering Transactions Using the Flashback Transaction Query Feature
  • Retrieving Row History Information Using the Flashback Version Query Feature
  • Recovering Table Data Using the Flashback Table Feature
  • Recovering Dropped Tables using Flashback Drop Feature
  • Flashing back a transaction
  • Using LogMiner Enhancements
  • Using the SQL Tuning Advisor
  • Using the SQL Access Advisor
  • Using the trcsess Utility to Consolidate Output from Trace Files
  • Oracle Database 11g Fault Management
  • Ease Diagnosis: Automatic Diagnostic Workflow
  • Automatic Diagnostic Repository
  • Incident Packaging Configuration
  • Running Health Checks
  • Using the SQL Repair Advisor
  • Viewing, Disabling, or Removing a SQL Patch
  • Managing & Using SQL Query Result Cache
  • Adaptive Cursor Sharing: Architecture
  • Temporary tablespace shrinkage
  • Using the client result cache
Live Online Training (Duration : 40 Hours) Fee On Request
Group Training Incl. Official Courseware
06 - 10 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 08 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training Incl. Official Courseware
4 Hours
8 Hours
Week Days

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Ultra-Fast Track

If you can't spare 40 hours. We can offer you an Ultra-Fast Track for 20 hours

Course Prerequisites
  • Basic Computer Knowledge.

Upon Completion of this Course, you will accomplish following:

  • Create a default permanent tablespace
  • Describe Automatic Storage Management 
  • Setup and modify Automatic SQL Tuning
  • Interpret reports generated by Automatic SQL Tuning
  • Minimize load requiements by specifying limits in backup time windows
  • Configure fined grained access to network services

Give an edge to your career with Oracle certification training courses. Students can join the classes for Oracle Database 9i To 11g DBA Training Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

Request More Information

Add Name and Email Address of participant (If different from you)