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