Prerequisites : DBA's with Oracle 9i database Knowledge
Duration : 4 Days (40 Hrs)

Oracle Database 10G

Space Management

1. Segment AdvSorted Hash Clustersisor


2. New Segment Resource Estimation


3. Online Segment Shrink


4. Proactive Tablespace Management


5. Undo Advisor

Bigfile Tablespace

1. Enhanced Partition Management in Enterprise Manager


2. Global Partitioned Indexes - Hash Partitioning


3. Local Partitioned Indexes Manageability Improvements


4. Temporary tablespace groups

RMAN Enhancements

1. Flash Backup and Recovery


2. Backup Compression

Drop Database

1. Automatic Channel Failover for Backup & Restore


2. Incrementally Updated Backups


3. Simplified Recovery Through Resetlogs

Flashback Any Error

1. Flashback Database


2. Flashback Table


3. Flashback Versions Query


4. Flashback Transaction Query


5. Flashback Drop

General Storage Management

1. Rename Tablespace


2. Redo Logfile Sizing Advisor


3. SYSAUX Tablespace


4. Copying Files using the Database Server

Automatic Storage Management
ASM General Architecture

Transaction Monitoring

1. End-to-End Tracing


2. Resumable Space Allocation Enhancements


3. Logminer enhancements


4. Resumable Space Allocation Enhancements

SQL Tuning Advisor

1. End-to-End Tracing


2. Resumable Space Allocation Enhancements


3. Logminer enhancements


4. Resumable Space Allocation Enhancements