Oracle Database 10g: Administration II

In this 3 day instructor led class, students will develop an advanced understanding of complex Oracle database concepts, maintenance and recovery routines, and database management.

Course Objective:  You will learn how to control and manage an Oracle installation.

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, SQL*Plus, and PL/SQL.

Prerequisites:  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

Delivery Method:  Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Hardware Requirements

  • P4 2600 Mhz processor or more
  • 1 GB RAM or more
  • 40 GB or larger hard disk
  • 2 additional 10 GB or larger hard disks
  • DVD-ROM or CD-ROM drive
  • 256 color video adapter

Platform Requirements

  • Windows

Software Requirements

  • Windows XP Professional
  • Oracle 10g Database Enterprise Edition

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.

Course Content

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

To Hire a proven Oracle Database Subject Matter Expert Consultant and Instructor who teaches this class, call 800-798-3901 today! 

Leave a Reply