Oracle Database 10g:New Features for Administrators

Installing, Upgrading, and Cloning Oracle Database 10g
Installing Oracle Database 10g
Upgrading a Database to Oracle Database 10g
Database Cloning
Enterprise Manager Enhancements

Managing Oracle Database 10g with the Advisory Framework
The Advisory Framework
Automatic Database Diagnostic Monitor
MTTR Advisor
Optimize Redo Logfile Size
Manage the Undo Tablespace
Reclaim Wasted Space from Tables and Indexes
Improve the Performance of SQL Queries Using SQL Tuning Advisor
Optimize SQL Statements by Using the SQL Access Advisor

Managing Storage in Oracle Database 10g
Monitor and Manage Server-Generated Alerts
Manage Tablespaces

Automating Storage Management
Automatic Storage Management
Set Up Initialization Parameters and Start an ASM Instance
Administer ASM Disk Groups
Migrate Your Database to ASM Using RMAN

Improving Backup and Recovery with New Enhancements
Restoring Data with Oracle Flashback
Configure and Manage the Flash Recovery Area
Improve Database Backups
Improving Restore and Recovery Operations

Using New SQL Features and Performance Enhancements
Managing Optimizer Statistics
Improved Support for Strings Using Regular Expressions
Write MERGE Statements with the New Conditions and Extensions
Use Additional Linguistic Comparison and Sorting Methods in SQL
Use Partitioned Outer Join Syntax for Densification
Simplify SQL by Using Interrow Calculations

Tuning Database Performance
Use the Performance Pages of the Database Control
Monitor and Maintain the Automatic Workload Repository
Diagnose Recent Issues with the Active Session History
Automate Shared Memory Management
Control Database Resources with Resource Manager Enhancements
Improving Performance with Additional Enhancements
Diagnose Performance Problems in Multitier Environments

Managing Scheduled Jobs
Simplify Management Tasks by Using the Scheduler
Reuse Scheduler Components for Similar Tasks
View Information About Job Executions and Job Instances

Loading and Unloading Data
Export and Import Using Data Pump
Unload Data into External Tables
Transportable Tablespaces and Different Platforms
Copy Files Using the Database Server

Securing Oracle Databases
Apply a Column-Level VPD Policy
Apply VPD Policy Types
Maximize Audit Efficiency Using Fine-Grained Auditing
Audit Database Changes with the Uniform Audit Trail

After completing this course, students will know how to:

Install and configure Oracle Database 10g, and identify the processes for upgrading and cloning existing databases.
Manage Oracle databases using the advisors that make up the advisory framework.
Manage storage in Oracle databases by using alerts and new tablespace features.
Use Automatic Storage Management to manage files.
Improve data stability by using enhancements to Oracle Flashback and new data backup, recovery, and restore features.
Optimize applications by using new SQL features and performance enhancements.
Tune database performance by identifying and using a variety of new performance-enhancing features.
Manage scheduled jobs using the Scheduler tool.
Load and unload data by using the Data Pump tool and other new features.
Increase security of Oracle databases using new VPD and auditing features.

Prerequisites

Students should have experience with Oracle9 i or equivalent database
administration experience. Oracle9 i certification is preferred.