Oracle 10G: New features for experienced DBAs

Concentrika poppy

Oracle 10G new features

About the course
The 2 day event is aimed at organizations with large systems, who are planning to migrate to Oracle 10G, from an earlier release, or who have already done so. The main changes that might concern or interest the DBA are covered during the event. This gives an appreciation on what is on offer from the release and how the new features presented might enhance the capabilities of the Oracle platform.

Audience

Experienced Oracle Version 9i DBAs

Prequisites
The course is for experienced Oracle Version 9i DBAs who are familiar with the features of the Oracle 9i release. Elementary knowledge is required of Oracle PLSQL as some of the practicals involve running administrative packages.

Duration 2 days

1. New features for database creation and management

• Changes in SQL*PLUS
• SYSAUX Tablespace
• Temporary tablespace groups
• Automated Storage Management
• Drop Database
• Decommissioned components
• Automated shared memory management
• Shared server configuration
• Revised directory structure under ORACLE_HOME
• N

4. 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

7. Backup and recovery new features

• Extended flashback functions
• RMAN enhancements
• Log Miner

2. Database resource manager improvements

• Database Resource Manager overview
• Adaptive consumer group mapping

5. Tablespace management

• Automated Storage Management
• Temporary tablespace groups
• Rename tablespace
• Bigfile tablespace
• Cross-platform transportable tablespaces

8. Data transfer and storage

• Asynchronous Change Data
• Enhanced Table Functions
• External Tables unload
• Enhanced MERGE functionality
• sqlldr and exp/imp
• 10G data pump expdb and impdb

3. Tuning improvements

• Buffer Cache flushing - user initiated
• Automated checkpoint tuning
• CPU Costing
• Dynamic sampling
• New and updated Optimizer hints
• PLAN_TABLE new columns
• Wait Model improvements
• SQL Access Advisor
• Materialized View tuning API - The new TUNE_MVIEW API
• Automatic Workload Repository (AWR)
• Automatic Database Diagnostic Monitor(ADDM)

6. Oracle10g networking

• Listener
• Streams

9. Security

• Virtual Private Database (VPD) Enhancements
- Column-Level VPD Policy
- Column Masking
- Policy Types
- Application Context Support for Parallel Queries
• Fine-Grained Auditing Enhancements
• Uniform Audit Trail
• Audit Trail Contents
• DBMS_CRYPTO