Course Description:

The complexity and flexibility of the Oracle10g database provide a major learning challenge for the Oracle DBA.  Jump start your knowledge of Oracle10g with this new course designed for working Oracle DBAs who need to quickly understand and apply the new features of Oracle10g.

Who Needs to Attend:

Database administrators who need to have a more complete understanding of Oracle10g’s new features.

 Prerequisites:

Basic understanding of Oracle SQL, SQL*Plus, PL/SQL and Oracle9i architecture and operation.

Course Contents:

SQL Enhancements

• SQL*Plus Enhancements

• Accent / Case Insensitive Sorts

• Regular Expressions

• New CONNECT BY Functionality

PL/SQL Enhancements

• RETURNING INTO Enhancements

• Compiler Enhancements

• Conditional Compilation

• New And Improved Oracle Packages

• FORALL enhancements

General Enhancements

• Automatic Undo Tuning

• Default Permanent Tablespaces

• EZConnect

• Data Guard Enhancements

• Log Miner Enhancements

• Redo Logfile Size Advisor

Server Installation

• Support For New Features

• Streamlined Installation

• Pre-Installation Requirements

• Storage Options At Installation

• Backup and Recovery Options

• Grid Control vs. Database control

• Use Of DBCA

• The Pre-Upgrade Installation Tool

• Database Upgrade Assistant

• Upgrading / Downgrading

Configuration Of The Server

• The New SYSAUX Tablespace

• EM – EMCTL / EMCA

• Cloning Databases

• Policy Management

• Enhancements For Response Files

• The Policy Framework

• Blackouts

Loading Data

• New Data Pump – Architecture And Use

• Monitoring Data Pump Jobs

• Import Transformations

• SQL*Loader

• The Use Of External Tables

• Direct Path Data Loads

Database And Data Transport

• Cross-Platform Transportable Tablespaces

• Transportable Database

• The Tablespace Repository

 Database Automation

• Automated Shared Memory Management

• The SGA Advisor

• Automatic Database Diagnostic Monitor

• Automatic Optimizer Statistics Collection

• Automatic Undo Retention Tuning

Infrastructure For Manageability

• Active Session History

• Management And Advisory  Framework

• Automatic Workload Repository Data

• AWR Baselines And Purging

• Server-Generated Alerts

• Views For Alerts And Metrics

Baseline Metric Management

• Baselines and Threshholds

• Enabling Baselining

• Setting Adaptive Alert Threshholds

• Creating Static Baselines

Application Tuning

• Automated Statistics Collection

• Query Optimization Enhancements

• Automated SQL Tuning

• SQL Tuning Advisor

The Scheduler

• Privileges Required

• Creating A Job / Job Class

• Creating A Window /  Schedule

• Job Chains And Events

Space Management

• Tablespace Monitoring

• Segment Advisor

• Shrinking Segments

Very Large Database Support

• Bigfile Tablespaces

• Temporary Tablespace Groups

Backup And Recovery Enhancements

• Flash Backup And Recovery

• The Flash Recovery Area

• Fast Recovery

• Block Change Tracking

• Compressed & Encrypted Backups

• RESETLOGS Enhancements

• Duration And Throttling Options

Flashback Enhancements

• Flash Recovery

• The Flash Recovery Area

• Flashback Database / Before Drop

• The Recycle Bin

• Flashback Versions

• Flashback Transactions Query

• Guaranteed Undo Retention

• Restore Points

• Transactional Change Tracking

Storage Enhancements

• Tablespace Rename

• Server File Copying

• Redo Log Size Advisor

Automated Storage Management

• Instance Creation

• Starting And Stopping An ASM Instance

• ASM Disk Groups And Files

Security Enhancements

• Virtual Private Database Enhancements

• Transparent Data Encryption