Oracle 10g for 8i DBA's (O1018) Training Course

Training Course Objectives

This course is intended to familiarise the Oracle 8i DBA with the new features of both Oracle 9i and Oracle 10g database, perhaps as part of a planned upgrade from 8i to 10g.

As well as offering the content of our 9i and 10g New Features courses, this course also discusses both the approach and issues concerned with the upgrade itself.

Who Should Attend

• Oracle 8i DBA's

Training Course Prerequisites

• Oracle 8i DBA knowledge
• View Learning Path

Training Course Duration

3 Days

Training Course Contents

Manageability

• Automatic Undo Management
• Oracle Managed Files
• Persistent Parameter Files
• Resumable Space Allocation
• DBMS_RESUMABLE Package
• Multiple Block Sizes
• Memory Management
• Automatic Segment Management
• Partitioning Enhancements
• Instance Management
• Other Manageability Improvements

Availability

• LogMiner Enhancements
• FlashBack Query
• Online Data Evolution
• Availability/Recoverability
• Oracle DataGuard

Shared Memory Management

• Manual Memory Allocation
• Setting up ASSM
• Non-dynamic SGA Buffers

Tablespace Management

• Default Permanent Tablespace
• Rename Tablespace
• SYSAUX Tablespace

Scheduler

• Programs/Schedules
• Jobs/Job Classes
• Windows
• Data Dictionary Views

Space Management

• Segment Advisor
• Shrinking Segments
• Undo Advisor
• Automatic Undo Retention Tuning

Improved VLDB Support

• Bigfile Tablespaces
• Temporary Tablespace Groups
• Partitioning Enhancements and Index Organized Tables
• Unusable Indexes
• Hash partitioned global indexes

Automated Storage Management

• ASM instances and database instances
• ASM Disk groups & files
• Data dictionary Views

Security Enhancements

• Default User Management
• Fine Grained Auditing
• Virtual Private Database Enhancements
• Uniform Audit Trail
• DBMS_CRYPTO

Oracle Tools/Utilities

• Flash Recovery Area
• Fast Incremental Backups
• Automatic Instance Creation for RMAN TSPITR
• Backupset Compression
• Limiting Backup Duration
• Enterprise Manager and DBCA
• Export, Import and Data Pump
• External Tables
• Cross-Platform Transportable Tablespaces

Automatic Workload Repository

• Automatic Statistics Collection
• Baselines
• Workload Repository Views
• AWR Reporting
• Feature Usage Metrics
• Active Session History (ASH)

Automatic Database Diagnostic

• ADDM Reporting
• Server Alerts
• Related Views
• SQL Tuning Advisor

Miscellaneous Tuning Features

• ETL Performance Enhancements
• Buffer cache flushing
• Optimizer Changes
• Gathering Data Dictionary Statistics

Flashback

• Flashback Features
• Enabling Flashback
• Flashback Query
• Flashback Table
• Flashback Drop (Recycle Bin)
• Flashback Database

8i to 10g Installation/Upgrade

• Using Export & Import to upgrade
• Upgrade tasks discussion
• Manual upgrade

Next Available Dates

iTrain delivers this course as company specific training. Please contact us for more information or course dates.