This course introduces students to the new features in Oracle Database 10g - the database for Grid computing. Students learn how to use Oracle Database 10g new features to increase database availability, to simplify database performance monitoring and tuning through the use of Oracle Database 10g Advisors, and to offer simplified database manageability. The course also covers security and some development platform changes that students need to understand if applications running in databases support the related features. Hands-on practice sessions give students an opportunity to examine many of the new features for themselves.

Upon completion of this class, participants will be given extra lab time to prepare them to successfully pass the Oracle certification exam.

Who Should Attend:

This course is valuable for programmers, Technical consultants, database administrators and support engineers.

Prerequisites:

Administration experience with Oracle9i Database .

Course Objectives:

Implement improved manageability features to simplify database management
Utilize database advisors to provide proactive database monitoring
Increase data availability through Oracle Database 10g features that offer improved point in time recovery
Assist developers using Oracle Database 10g features in their applications

Course Topics:

Introduction
How DBAs Spend Their Time
Oracle Database 10g Manageability Goals
Oracle Database 10g Solution: Self-Managing Database
Grid Computing
Oracle Database 10g: The Database for the Grid

Installation
Installation Performance Enhancements
Installation New Feature Support
Automatic pre & post install validations
CD pack contents

Server Configuration
Database Features Usage Tracking
Automatic Enterprise Manager Configuration
Simplified Initialization Parameters
Simplified Database Install

Load and Unload Data
Cross-platform Transportable Tablespaces
External Tables Unload
DataPump Export and Import Utilities

Automatic Management
Automatic Checkpoint Tuning
Automatic Database Diagnostic Monitor
Automatic Shared Memory Tuning
Automatic Optimizer Statistics Collection
Automatic Undo Retention

Manageability Infrastructure
Advisory Framework
Automatic Routine Administration Tasks
Server-generated Alerts / Threshold-based Alerts
Automatic Workload Repository

Application Management and Availability
SQL Access Advisor
SQL Tuning Advisor
New performance overview charts in EM
Rule-based optimization (RBO) obsolescence

SQL Support for Analytical Applications
MERGE Command Enhancements
Partitioned Outer Join
Integrating Interrow Calculations in SQL
Summary Management Enhancements

System Resource Management
Setting Idle Timeouts
Switching Back to the Initial Consumer Group at End of Call
Database Resource Manager - Adaptive Consumer Group Mapping
Monitoring the Resource Manager

The Scheduler
Core Scheduler Features
Privileges for Scheduler Components
Calendaring Expressions
Advanced Scheduler Concepts

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

Improved VLDB Support
Bigfile Tablespace
Enhanced Partition Management in Enterprise Manager
Global Partitioned Indexes - Hash Partitioning
Local Partitioned Indexes Manageability Improvements
Temporary tablespace groups

RMAN Enhancements
Flash Backup and Recovery
Backup Compression
Drop Database
Automatic Channel Failover for Backup & Restore
Incrementally Updated Backups
Simplified Recovery Through Resetlogs

Flashback Any Error
Flashback Database
Flashback Table
Flashback Versions Query
Flashback Transaction Query
Flashback Drop

General Storage Management
Rename Tablespace
Redo Logfile Sizing Advisor
SYSAUX Tablespace
Copying Files using the Database Server

Automatic Storage Management
Data mirroring with ASM
ASM Dynamic Rebalancing
ASM Striping
ASM General Architecture
ASM Disk Groups
Failure Groups

Maintain Software
Oracle Database 10g Upgrade Paths
Easy Upgrade (key DBUA features / one script upgrade)
Upgrade Information Tools (pre/post)

Security Enhancements
VPD Static and Dynamic Policies
Column-level VPD
Uniform Audit Trail

Miscellaneous New Features
Transaction Monitoring
End-to-End Tracing
Logminer Enhancements
Resumable Space Allocation Enhancements
Regular Expression functions

Return to top

ACCA