Oracle Database 10g Administration:Advanced

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 Database Performance
Improve Database Performance Using 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 Different Storage Options
Rebuild Indexes Online

Restoring Data With Oracle Flashback
Recovering Data Using Flashback Technology
Flashback the Database 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
Perform Database Recovery Through a RESETLOGS Operation
Detect Database Corruption

Configuring the Recovery Manager (RMAN)
Recovery Manager
Configure the RMAN Environment

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 (ASM)
Automatic Storage Management
Set up Initialization Parameters and 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 and Job Instances

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

After completing this course, students will know how 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.

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