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

Duration : 5 Days (40 Hours)

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

This course offers Oracle Database Administrators (DBAs) a comprehensive overview of Oracle Database 11g, an enterprise-grade RDBMS built for large-scale, cloud, or hybrid cloud environments. Covering new features, enhancements, and setup, the course guides DBAs through configuring, creating, backing up, and restoring databases. By completing this course, DBAs will optimize their utilization of Oracle Database 11g, effectively transition from previous versions, and leverage their expertise in the evolving environment.

Intended Audience:

  1. Experienced Oracle 9i Database Administrators
  2. Individuals with a basic understanding of Oracle Database technology and concepts
  3. Those with practical experience in managing and maintaining Oracle 9i Databases
  4. Professionals familiar with some of the new features in Oracle Database 11g (beneficial but not required)
  5. DBAs looking to enhance their expertise and transition their skills from Oracle 9i to Oracle 11g
  6. IT personnel seeking to learn the key differences and enhancements between Oracle 9i and 11g for effective database administration.

Learning Objectives of Oracle Database 11g: New Features for Oracle 9i DBAs:

The Oracle Database 11g: New Features for Oracle 9i DBAs Training is composed of the following learning objectives which can be achieved in the given time span:1. Learning to manage advanced database features of the 11g version of Oracle Database.
2. Understanding the configuration options for different versions of Oracle databases.
3. Learning about the new features of Oracle Database 11g including performance enhancements and Oracle ASM.
4. Gaining knowledge on database structures, including: tablespaces, Oracle Streams, logical structures, and rollback segments.
5. Working with the grid infrastructure and Oracle Data Guard for enhanced data backup and replication capabilities.
6. Understanding the use of Recovery Manager (RMAN) for efficient database recovery and backup in Oracle 11g databases.
7. Acquiring skills on Oracle Streams and advanced replication techniques.
8. Gaining troubleshooting and diagnostic skills for better database management using the latest Oracle utilities.

 Module 1: Planning Your Upgrade to Oracle Database 11g

  • Steps to Upgrade to Oracle Database 11g
  • Choosing an Upgrade Method
  • Performing Character Conversion

 Module 2: Upgrading the Oracle Database 11g

  • Installing Oracle Database 11g Software
  • Applying Oracle Software Patches
  • Creating a Database

 Module 3: Real Application Testing

  • 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

 Module 4: Upgrading Your Database Using other Methods

  • 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

 Module 5: Performing Post-Upgrade Steps

  • 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

 Module 6: Using EM: Database Control and Grid Control

  • 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

 Module 7: Proactively Maintaining the Database

  • Oracle Database 11g: Self-Managing Database
  • Automatic Workload Repository
  • Job Scheduler Concepts
  • Server-Generated Alerts
  • Advisor Framework
  • Automatic Database Diagnostic Monitor
  • Configuring Alerts

 Module 8: Managing System Resources

  • 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

 Module 9: Automating Tasks with the Scheduler

  • Scheduler Concepts
  • Using Scheduler Programs
  • Windows and Resources
  • Administering the Scheduler

 Module 10: Managing Memory Structures

  • Enabling Automatic Memory Management
  • Modifying Parameters for Automatically Managed Components
  • Modifying Parameters for Manually Sized Components
  • Monitoring Automatic Memory Management

 Module 11: Managing Database Storage Structures

  • 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

 Module 12: Implementing Automatic Storage Management (ASM)

  • ASM: Key Features and Benefits
  • ASM: General Architecture
  • Accessing an ASM Instance
  • ASM Administration
  • Database Instance Parameter Changes
  • Migrating Your Database to ASM

 Module 13: Managing Database Space

  • Understanding Automatic Undo Management
  • Specifying the Undo Management Mode
  • Setting the Undo Management Initialization Parameters
  • Using the Undo Advisor

 Module 14: Administering Users and Database Security

  • 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

 Module 15: Managing Schema Objects

  • 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

 Module 16: Accessing and Loading Data

  • Using Data Pump to Import and Export Data
  • Managing External Tables
  • Cross-Platform Transportable Tablespaces

 Module 17: Performing Backup and Recovery Operations

  • 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

 Module 18: Recovering From User Errors

  • 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

 Module 19: Managing Performance

  • Using the SQL Tuning Advisor
  • Using the SQL Access Advisor
  • Using the trcsess Utility to Consolidate Output from Trace Files
  • Using DBMS_MONITOR

 Module 20: Diagnosability Enhancements

  • 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

 Module 21: Miscellaneous New Features

  • Managing & Using SQL Query Result Cache
  • Adaptive Cursor Sharing: Architecture
  • Temporary tablespace shrinkage
  • Using the client result cache

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

• A solid understanding of the Oracle database architecture
• Knowledge of database administration fundamentals
• Knowledge of Oracle 9i database tools and utilities
• Experience in configuring and managing an Oracle 9i database
• Familiarity with the Oracle RMAN utility

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability

Classroom

  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention

Onsite

  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.
×