Back to Search Results

Training Course Summary:

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.

Pre-Requisites:

Oracle 8i DBA knowledge

Who Should Attend:

Oracle 8i DBA's

Training Course Overview/Content:

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
back to top
Availability
LogMiner Enhancements
FlashBack Query
Online Data Evolution
Availability/Recoverability
Oracle DataGuard
back to top
Shared Memory Management
Manual Memory Allocation
Setting up ASSM
Non-dynamic SGA Buffers
back to top
Tablespace Management
Default Permanent Tablespace
Rename Tablespace
SYSAUX Tablespace
back to top
Scheduler
Programs/Schedules
Jobs/Job Classes
Windows
Data Dictionary Views
back to top
Space Management
Segment Advisor
Shrinking Segments
Undo Advisor
Automatic Undo Retention Tuning
back to top
Improved VLDB Support
Bigfile Tablespaces
Temporary Tablespace Groups
Partitioning Enhancements and Index Organized Tables
Unusable Indexes
Hash partitioned global indexes
back to top
Automated Storage Management
ASM instances and database instances
ASM Disk groups & files
Data dictionary Views
back to top
Security Enhancements
Default User Management
Fine Grained Auditing
Virtual Private Database Enhancements
Uniform Audit Trail
DBMS_CRYPTO
back to top
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
back to top
Automatic Workload Repository
Automatic Statistics Collection
Baselines
Workload Repository Views
AWR Reporting
Feature Usage Metrics
Active Session History (ASH)
back to top
Automatic Database Diagnostic
ADDM Reporting
Server Alerts
Related Views
SQL Tuning Advisor
back to top
Miscellaneous Tuning Features
ETL Performance Enhancements
Buffer cache flushing
Optimizer Changes
Gathering Data Dictionary Statistics
back to top
Flashback
Flashback Features
Enabling Flashback
Flashback Query
Flashback Table
Flashback Drop (Recycle Bin)
Flashback Database
back to top
8i to 10g Installation/Upgrade
Using Export & Import to upgrade
Upgrade tasks discussion
Manual upgrade