Welcome to Comnet Group Inc.


Oracle Database 10g Administration II

Course number: CGIOD10GII40

Course Description:

A good Oracle database administrator must gain and maintain a mastery of his or her environment, its physical structures, and its maintenance routines. An administrator must understand the data being stored well enough to tune and improve performance, to anticipate and prevent data failure, and to recover lost data should a failure occur. In this course, you will develop an advanced understanding of complex Oracle database concepts, maintenance and recovery routines, and database management. You have an Oracle installation and need to broaden your knowledge of advanced Oracle administrative functionality so that you can maintain the healthiest possible database.

Performance-Based Objectives
Upon successful completion of this course, students will be able to:

  • monitor the database.
  • monitor and manage memory.
  • monitor and manage database performance.
  • monitor and manage storage.
  • restore data with Oracle Flashback.
  • back up and recover data.
  • configure Oracle’s Recovery Manager (RMAN).
  • perform RMAN backups.
  • perform RMAN recoveries.
  • utilize Automatic Storage Management.
  • automate tasks with the Scheduler.
  • identify and configure globalization support configuration information.

Target Student:

This course is intended for Oracle Database 10g Administrators, Sales Consultants, Support Engineers, Oracle Software Developers and Technical Consultants. Students should have some knowledge of Oracle database utilities, architecture, and terminology, including some experience with SQL*Plus, iSQL*Plus, and PL/SQL.


The following courses are suggested prerequisites:

  • Introduction to Programming (Second Edition)
  • SQL: Fundamentals of Querying (Second Edition)
  • Object-Oriented Programming: Principles
  • Java 2: Object-Oriented Analysis and Design using UML
Course Outline
Lesson 1: Monitoring the Database
  • Topic 1A: Diagnose Issues Using Trace Files and the Alert Log
  • Topic 1B: Adjust Thresholds for Tracked Metrics
  • Topic 1C: Secure the Listener
Lesson 2: Monitoring and Managing Memory
  • Topic 2A: Manually Configure SGA Parameters for Various Memory Components
  • Topic 2B: Using Automatic Shared Memory Management
  • Topic 2C: Configure Automatic PGA Memory Management
Lesson 3: Monitoring and Managing Database Performance
  • Topic 3A: Improve Database Performance Using the SQL Tuning Advisor
  • Topic 3B: Manage Resources
  • Topic 3C: Tune Redo Log and Archive Log Operations
Lesson 4: Monitoring and Managing Storage
  • Topic 4A: Manage Tablespace Usage
  • Topic 4B: Reclaim Wasted Space from Tables and Indexes
  • Topic 4C: Estimate the Size of New Tables and Indexes
  • Topic 4D: Improve Query Performance Using Different Storage Options
  • Topic 4E: Rebuild Indexes Online
Lesson 5: Restoring Data With Oracle Flashback
  • Topic 5A: Recovering Data Using Flashback Technology
  • Topic 5B: Flashback the Database Using the OEM Recovery Wizard
  • Topic 5C: Maintaining the Flash Recovery Area
  • Topic 5D: Using Automatic Undo Retention Tuning
Lesson 6: Backing Up and Recovering Data
  • Topic 6A: Recover Tablespaces and the Password File
  • Topic 6B: Perform Incomplete Recoveries
  • Topic 6C: Perform Database Recovery Through a RESETLOGS Operation
  • Topic 6D: Detect Database Corruption
Lesson 7: Configuring the Recovery Manager (RMAN)
  • Topic 7A: Recovery Manager
  • Topic 7B: Configure the RMAN Environment
Lesson 8: Performing RMAN Backups
  • Topic 8A: Create RMAN Image Copies
  • Topic 8B: Conduct RMAN Online Backups
  • Topic 8C: Conduct RMAN Incremental Online Backups
  • Topic 8D: Back Up Archive Logs
  • Topic 8E: Manage RMAN Backups
Lesson 9: Performing RMAN Recoveries
  • Topic 9A: Perform an RMAN Complete Recovery
  • Topic 9B: Perform an RMAN Incomplete Recovery
  • Topic 9C: Repair Block Corruptions Using RMAN
Lesson 10: Utilizing Automatic Storage Management (ASM)
  • Topic 10A: Automatic Storage Management
  • Topic 10B: Set up Initialization Parameters and Start an ASM Instance
  • Topic 10C: Administer ASM Disk Groups
  • Topic 10D: Migrate Your Database to ASM Using RMAN
Lesson 11: Automating Tasks with the Scheduler
  • Topic 11A: Simplify Management Tasks by Using the Scheduler
  • Topic 11B: Reuse Scheduler Components for Similar Tasks
  • Topic 11C: View Information About Job Executions and Job Instances
Lesson 12: Using Globalization Support Objectives
  • Topic 12A: Obtain Globalization Support Configuration Information
  • Topic 12B: Customize Language-Dependent Behavior
  • Topic 12C: Specify Different Linguistic Sorts for Queries
  • Topic 12D: Use Datetime Datatypes
  • Topic 12E: Query Data Using Case-Insensitive and Accent-Insensitive Sorting

Available Formats

Live Online