Oracle 10g New Features

• Flash Recovery Area
  

• Recycle Bin (logical structure for locally managed, non-system tablespaces)
  

• Bigfile Tablespace
  

• Oracle Easy Connect : New net service connection resolution technique in 10g
  

• PL/SQL compiler warnings
  

• Data Pump
  

• Flashback Table
  

• Two new background processes: MMON (Memory Monitor) and MMNL (Memory Monitor Light)
  

• Compressed backup set regardless of whether blocks in the datafiles are used or unused in RMAN. Works with only backupsets, not image copies
  

• Block change tracking in RMAN. CTWR (Change Tracking Writer) is a new process which works with the new block changing tracking feature in 10g for fast RMAN incremental backups. Is automatically used by RMAN. This improves performance because RMAN doesn't have to scan the whole datafile during backup.
  

• RMAN has introduced control file autobackup
  

• Flashback Database: Database should be in ACHIVELOG mode and logging should be enabled. Uses flashback logs that are stored in flash recovery area to perform the recovery. However, other flashback technologies use undo data for recovery operation.
  

• Automatic Storage Management: The Migrate Database to ASM job uses RMAN to convert your database to ASM.
  

• Automatic Shared Memory Management (ASMM) : Oracle recommends using ASMM over the use of Memory Advisor. In OEM, Administration --> Memory Parameters --> Under SGA you can see if ASMM is enabled or disabled . MMAN (Memory Manager) process takes care of this.
  

• SQL_ID new in 10g, is a hash value that uniquely identifies a single SQL statement within a database.
  

• Data Dicitonary Statistics, OS statistics, System statistics
  

• DBMS_ADVISOR package
  

• Automatic SQL tuning desined into the new query optimizer that totally replaces the need for manual SQL tuning.
  

• Sorted Hash Clusters
  

• Automated Channel failover in RMAN. In order to use this feature multiple channels must be allocated.