Back to Search Results

Training Course Summary:

This course is designed to introduce the new features and enhancements in Oracle10g database.

The course has been designed for existing DBA's, familiar with previous versions of Oracle's family of RDBMS products (7, 8, 8i, 9i).

The course fulfils the need of DBA's to remain up to date with new 9i development as well as considering the impact/opportunities available through the implementation of Oracle 10g within an existing Oracle business infrastructure.

Pre-Requisites:

Understanding of general Oracle architectures (7/8/8i/9i)
Oracle RDBMS experience

Who Should Attend:

Oracle Database Administrators
Oracle Technical IT Managers
Oracle Support Engineers
Oracle Application Developers
Oracle Project Managers

Training Course Overview/Content:

Introduction
Oracle 10g and Grid Computing
Database Features
back to top
Shared Memory Management
Manual Memory Allocation
Setting up Automatic Shared Memory Management
Non-dynamic SGA Buffers
Tablespace Management
Default Permanent Tablespace
Rename Tablespace
SYSAUX Tablespace
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
Improved Segment Size Estimation
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
Features
ASM instances and database instances
ASM Disk groups
ASM Files
Data dictionary Views
back to top
Security Enhancements
Virtual Private Database Enhancements
Uniform Audit Trail
DBMS_CRYPTO
back to top
Utilities
Export, Import and Data Pump
Directories and files
Example of a Data Pump Job
Command Line Interactive Jobs
Object selection
Data Pump Features
Data Pump API
External Tables
Cross-Platform Transportable Tablespaces
back to top
Automatic Workload Repository
AWR Features
Automatic Statistics Collection
Baselines
Workload Repository Views
AWR Reporting
Feature Usage Metrics
Active Session History (ASH)
back to top
ADDM
Features
ADDM Reporting
Server Alerts
Related Views
SQL Tuning Advisor
SQL Tuning Advisor Features
back to top
Miscellaneous Tuning Features
Buffer cache flushing
Optimizer Changes
Gathering Data Dictionary Statistics
back to top
Flashback
Flashback Features
Enabling Flashback
Flashback Query
Additional Query Functions
Flashback Version Query
Flashback Transaction Query
Flashback Table
Flashback Drop (Recycle Bin)
Flashback Database
back to top
RMAN Enhancements
Flash Recovery Area
Fast Incremental Backups
Using Image Copies with Incremental Backups
Image Copies and the BACKUP Command
Catalog Maintenance
Automatic Instance Creation for RMAN TSPITR
Global Stored Scripts
Backupset Compression
Restore Preview
Limiting Backup Duration
More Robust Backup and Restore