Oracle 10G New Features for DBAs

AUDIENCE: This course is aimed at database administrators and managers in organisations with large systems who are planning to migrate to Oracle 10G from an earlier release or who have already done so.
PREREQUISITES: Delegates should be experienced Oracle 9i DBAs who are familiar with the features of the Oracle 9i release.
DURATION: 4 days. Hands on.
OBJECTIVES: The main changes that might concern or interest the DBA are covered during the course, allowing you to not only manage the new database but to be aware of options as reasons for migrating your Oracle image to the new release. You will gain an appreciation on what is on offer from the release and how the new features presented might enhance the capabilities of the Oracle platform. The event is enhanced with hands-on investigations of some of the 10G new features. Please note that Oracle 10G Grid computing is a specialised application in its own right and is not covered in detail in this new features overview.
COURSE CONTENT:
New Features for Database Creation and Deletion
SYSAUX Tablespace
Automated Storage Management
Drop Database

Database Resource Manager Improvement
Database Resource Manager overview
Adaptive consumer group mapping
Fixed CPU quota
Integration of Resource Manager and Profiles

Tuning Improvements
Buffer Cache flushing - user initiated
Automated checkpoint tuning
CPU Costing
Dynamic sampling
Easy transaction recovery monitoring

Application Tuning
Single-set aggregates in DML returning clause
New and updated Optimizer hints
Wait Model improvements
SQL Access Advisor
Materialized View tuning

Data Dictionary Changes
New static Data Dictionary views
New dynamic performance views
Static data dictionary views have new columns
Dynamic performance views have new columns
New initialisation parameters

Tablespace Management
Temporary tablespace groups
Rename tablespace
Bigfile tablespace
Cross-platform Transportable Tablespaces
Extended ROWID format
Automated Storage Management (ASM)

Backup and Recovery New Features
Extended flashback functions
RMAN enhancements
Log Miner

Data Transfer and Storage
Asynchronous Change Data
Enhanced Table Functions
Enhanced MERGE functionality
sqlldr and exp/imp
Oracle 10G streams
External Tables unload

PPJ07/01