Skip to Content

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

expand or collapse the menu Accessibility

expand or collapse the menu Web Development

expand or collapse the menu Adobe / Macromedia Web

expand or collapse the menu Programming

expand or collapse the menu Databases

expand or collapse the menu Professional Courses

expand or collapse the menu Adobe

expand or collapse the menu Microsoft SharePoint

expand or collapse the menu Technical

expand or collapse the menu Geographic (GIS)

expand or collapse the menu Microsoft Office

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

Oracle Database Administration – Advanced

3 day course

View Detailed Outline in PDF format

Get Adobe Reader

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.

Course Topics:

(for a full detailed outline, visit our PDF link above)

Monitoring the Database

  • Diagnose Issues Using Trace Files and the Alert Log
  • Adjust Thresholds for Tracked Metrics
  • Secure the Listener

Monitoring and Managing Memory

  • Manually Configure SGA Parameters for Various Memory Components
  • Using Automatic Shared Memory Management
  • Configure Automatic PGA Memory Management

Monitoring and Managing Performance

  • Improve Performance w/the SQL Tuning Advisor
  • Manage Resources
  • Tune Redo Log and Archive Log Operations

Monitoring and Managing Storage

  • Manage Tablespace Usage
  • Reclaim Wasted Space from Tables and Indexes
  • Estimate the Size of New Tables and Indexes
  • Improve Query Performance Using Storage Options
  • Rebuild Indexes Online

Restoring Data with Oracle Flashback

  • Recovering Data Using Flashback Technology
  • Flashback Using the OEM Recovery Wizard
  • Maintaining the Flash Recovery Area
  • Using Automatic Undo Retention Tuning

Backing Up and Recovering Data

  • Recover Tablespaces and the Password File
  • Perform Incomplete Recoveries
  • The RESETLOGS Operation
  • Detect Database Corruption

Configuring the Recovery Manager (RMAN)

Performing RMAN Backups

  • Create RMAN Image Copies
  • Conduct RMAN Online Backups
  • Conduct RMAN Incremental Online Backups
  • Back Up Archive Logs
  • Manage RMAN Backups

Performing RMAN Recoveries

  • Perform an RMAN Complete Recovery
  • Perform an RMAN Incomplete Recovery
  • Repair Block Corruptions Using RMAN

Utilizing Automatic Storage Management

  • Automatic Storage Management (ASM)
  • Set up Initialization Parameters
  • Start an ASM Instance
  • Administer ASM Disk Groups
  • Migrate Your Database to ASM Using RMAN

Automating Tasks with the Scheduler

  • Simplify Management Tasks by Using the Scheduler
  • Reuse Scheduler Components for Similar Tasks
  • View Information About Job Executions & Instances

Using Globalization Support Objectives

  • Obtain Globalization Support Configuration Info
  • Customize Language-Dependent Behavior
  • Specify Different Linguistic Sorts for Queries
  • Use Datetime Datatypes
  • Query Data Using Case-Insensitive and Accent-Insensitive Sorting