Oracle Database 10g: New Features for Administrators Course

This course reviews all of the major administration features and improvements introduced with version 10g of the Oracle database. Participants will be able to apply their experience with previous releases of the Oracle database to this new release, which offers numerous productivity and manageability improvements.

The target audience for this course is database administrators with experience using Oracle9i, wanting to learn about the new and modified features introduced in Oracle10g.

Upon completion of this course, the participant will be able to:
> Install and initially configure a database instance
> Load and unload data between databases, including use of the Data Pump architecture
> Enable and configure automatic database management
> Enable and configure manageability features
> Enable and use general storage management and automatic storage management (ASM)
> Exploit new security enhancements to create a trusted database environmenth

Database Server Installation & Configuration
Simplified Database Install
Enterprise Management Configuration
Simplified Initialization Parameters
Database Features Usage Tracking
Database Server Installation & Configuration

Load & Unload Data
The Data Pump Architecture
Expdp & Impdp Utilities
Using The Data Pump Expdp Utility
Using The Data Pump Impdp Utility
Cross-Platform Transportable Tablespaces
Load & Unload With External Tables

Automatic Management
About Automatic Management
Automatic Checkpoint Tuning
Automatic Shared Memory Management
Automatic Optimizer Statistics Collection
Gather_Stats_Job()
Automatic Undo Retention
Automatic Database Diagnostic Monitor

Manageability Infrastructure
About The Advisory Framework
Automatic Routine Administration Tasks
Server Generated Alerts
Dbms_Server_Alertset_Threshold()
Dbms_Server_Alertget_Threshold()
Automatic Workload Repository

Application Management & Availability
SQL Access Advisor
SQL Tuning Advisor
Dbms_SQLtune()
New Performance Overview Charts
Rule-Based Optimization Obsolescence

SQL Support For Analytical Applications
Merge Command Enhancements
Partitioned Outer Joins
Integrating Inter-Row Calculations In SQL
Materialized View Enhancements

System Resource Management
Setting Idle Timeouts
Switching Back To Initial Consumer
Mappings With Database Resource Manager
Cpu_Mth=>Run-To-Completion
Cpu_Mth=> Ratio
Monitoring The Database Resource Manager

The Scheduler
Core Scheduler Features
Privileges For Scheduler Components
Creating A Scheduler Job
Advanced Scheduler Concepts

Space Management
The Segment Advisor
Segment Resource Estimation
Online Segment Shrink
Proactive Tablespace Management
Undo Advisor
Sorted Hash Clusters

Improved Vldb Support
About Bigfile Tablespaces
Enhanced Partition Management
Hash-Partitioned Global Indexes
Local Partitioned Indexes
Temporary Tablespace Groups

Rman Enhancements
Flash Backup & Recovery
Enhanced Online Backup Mode
Backup Compression
Rman Enhancements
Incrementally Updated Backups
Simplified Recovery Through Resetlogs

Flashback Any Error
Introduction
About Flashback Technology
Flashback Database
Flashback Table
Flashback Versions Query
Flashback Transaction Query
Flashback Drop

General Storage Management
Rename Tablespace
Redo Logfile Size Advisor
Sysaux Tablespace
Copying Files Using The Database Server
Default Permanent Tablespace

Automatic Storage Management
Automatic Storage Management
The ASM Instance
ASM Administration
ASM Files
Migrating The Database To ASM

Security Enhancements
Virtual Private Database
Static And Dynamic Policies
The Audit Trail

Miscellaneous New Features
Transaction Monitoring
Client Connect Configuration
Simplified Shared Server Configuration
Logminer Enhancements
Resumable Space Allocation Enhancements
Miscellaneous Features

Participants should have experience administering production databases using Oracle9i or Oracle8i or earlier.