O1018 - Oracle 10g for 8i DBA's
Availability
| Date | Duration | Price | Location | Enrolment |
|---|
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.
Training Course Contents
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
Who Should Attend
Pre Requisites
|
