Oracle 10g New Features for Administrators - ORA512

This class will introduce the experienced Oracle DBA to the new features contained in Oracle Database 10g. As students are introduced to the various new features, labs will reinforce the material presented in this course. Once this course is completed, the student will have gained the foundational knowledge to begin to administer Oracle 10g databases.
Course ID: ORA512

Duration: 5 days

Audience: Database administrators, application developers, and system administrators.

Prerequisites: Oracle 9i DBA Fundamentals 1, or equivalent experience.
Topics:

Migrating to Oracle10g

• The Different Editions of Oracle Database 10g
• Oracle Database Installation New Features
• The SYSAUX Tablespace
• 10g Upgrade Paths and Methods
• Database Upgrade Assistant (DBUA)
• Manual Upgrade
• Preparing to Upgrade to Oracle10g
• Rolling Back to a Previous Version
• Steps to Roll Back

Database Extraction and Loading New Features

• Cross-Platform Transportable Tablespaces
• Transporting a Tablespace Between Platforms
• Converting the Byte Format
• New Oracle Database External Table Features
• External Table Creation in Parallel
• The Oracle Data Pump Architecture
• Configuring the Database to Use Data Pump
• Using the expdp and impdp Tools
• Import and Export Via the Oracle Data Pump
• Using Interactive Mode

Tuning and Management

• Basic Initialization Parameters
• Automatic Shared Memory Management
• Configuring Automatic Shared Memory
• FLUSHING the Buffer Cache
• New 10.2 Tuning and Management Features
• Automatic Statistics Collection
• Automatic Undo Management and Tuning
• Guaranteed Undo Retention
• Automatic Checkpoint Tuning
• Using the DBMS_SQLTUNE Package
• SQL Trace and DBMS_MONITOR

Oracle10g Advisor Framework and Advisors

• The Advisor Framework
• Automatic Workload Repository
• Managing AWR
• Automatic Database Diagnostic Monitor
• SQL Tuning Advisor
• SQL Access Advisor
• Segment Advisor
• Undo Advisor

OEM: The Database Control

• Introducing Oracle Enterprise Manager
• Oracle Database Control Home Page
• Starting and Using Database Control
• Database Control Performance Page
• Administration and Maintenance Home Pages
• Determine Which Database Features are in Use
• MMON
• Configuring Server-Generated and Threshold-Generated Alerts
• Automating Routine Administrative Tasks

Server Management New Features

• Default User Tablespaces
• Rename Tablespaces
• Temporary Tablespace Groups
• Bigfile Tablespaces
• Dropping Empty Datafiles
• Drop Database Command
• Shared Server Changes

New Segment Features

• New Table Monitoring Behaviors
• Hash-Partitioned Global Indexes
• Skipping Unusable Indexes
• New Partitioned Index Management Features
• Sorted Hash Clusters
• Shrinking Segments Online
• Estimating Segment Resource Requirements
• Materialized Views

New Security Features

• Fine-Grained Auditing
• Virtual Private Database
• Column-Level VPD
• Column-Level VPD Example
• The DBMS_ CRYPTO Package
• Transparent Data Encryption

Availability and Recovery - RMAN

• Introducing the Flash Recovery Area
• Configuring and Managing the Flash Recovery Area
• RMAN Flash Backup and Recovery
• RMAN Backup Compression
• DROP DATABASE and UNREGISTER DATABASE
• CATALOG and UNCATALOG Commands
• Other RMAN New Features

Availability and Recovery - Flashback Database

• Incremental Backup Changes
• Flashback Database
• FLASHBACK TABLE
• Flashback Drop
• Flashback Versions
• Flashback Transactions
• Simplified Recovery Through Resetlogs

The Scheduler

• Scheduler - Introduction
• Architecture of the Scheduler
• Job Class and Windows
• Privileges Needed for Scheduler Components
• Creating Jobs, Programs, and Schedules<