Oracle 9i DBA New Features

Course code: O925

2 days

This course is designed to introduce the new features and enhancements in Oracle 9i database.

Course content >

Who Should Attend?




Course Contents

This course is designed to introduce the new features and enhancements in Oracle 9i database.

The course has been designed for existing DBA's, familiar with previous versions of Oracle's family of RDBMS products (7, 8, 8i).

The course fulfils the need of DBA's to remain up to date with new 9i development as well as considering the im-pact/opportunities available through the implementation of Oracle 9i within an existing Oracle business infrastructure

Training Course Contents


  • Locally Managed Tablespaces
  • Multiple Block Sizes
  • Memory Management
  • Automatic Segment Management
  • Instance Management
  • Monitoring Index Usage
  • Default Temporary Tablespace
  • Metadata API
  • Automatic Undo Management
  • Oracle Managed Files
  • Persistent Parameter Files
  • Resumable Space Allocation
  • 9i Partitioning Enhancements
  • Default User Management
  • Fine Grained Auditing

Performance & Scalability

  • ETL Performance Enhancements
  • Bitmap Join Indexes
  • Database Object Enhancements
  • Additional Performance Improvements
  • Real Application Clusters


  • Configuration
  • Connecting
  • Customising
  • Work Screen
  • History
  • Preferences
  • SQL for DBA Commands


  • CURSOR_SHARING parameter
  • 9i Development Platform


  • Oracle 9i Virtual Private Database Feature
  • Fine-grained Auditing
  • Secure Application Role

Availability & Recoverability

  • FlashBack Query
  • Online Data Evolution
  • Availability and Recoverability
  • Multiple, Remote Archival of Redo Logs
  • LogMiner Enhancements
  • Recovery Manager
  • Configurable Parameters
  • Block Level Recovery
  • SPFILE and Controlfile Backups

Oracle Data Guard

  • Data Guard Features
  • Network Configuration
  • Creating the Standby Database
  • Failover without Data Guard
  • Failover Using Data Guard
  • Role Transitions Using Data Guard
  • Data Guard Protection Modes
  • Logical Standby Databases
  • Restrictions on Logical Standby Databases
  • Creating a Logical Standby Database
  • Logical Standby Failover and Switchover
  • Data Guard Manager

Oracle Tools/Utilities

  • Enterprise Manager and DBCA
Contact us for more information