Oracle 9i for Experienced Oracle 8i Database Administrators

4 Day Course
Code OR89

This course has been retired. Please view currently available Oracle DBA Training Courses.

Modules

Topics Covered (20 topics)

  • Overview of the New Features in Oracle9i
  • Administration Tools
  • Upgrade and Migration to Oracle9i
  • Installation and Configuration of an Oracle database
  • Oracle Managed Files
  • Managing Initialization Parameters
  • Managing Redo Logs and Control Files
  • Managing Disk I/O
  • Managing Undo Data
  • Memory Management New Features
  • SQL and PL/SQL New Features
  • Optimizer and Index New Features
  • Database Resource Manager Enhancements
  • Advanced Replication Enhancements
  • LogMiner New Features
  • Overview of Real Application Clusters
  • Backup, Restore and Recovery New Features
  • Data Guard - Standby Database Enhancements
  • National Language Enhancements
  • Desupported and Deprecated Features

Prerequisites

A good working knowledge of SQL, PL/SQL and of Oracle8i administration and backup and recovery functions. Pre-Requisites Courses: Introduction to SQL (ISQL); PL/SQL (OPI).

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .

Sections