Difference between Oracle database 9i and 10g & Difference Between Oracle database 10g and 11g

Summary Of Differences Between oracle Database 9i and 10g.

The below Points are completely New in oracle database 10g (Not there in oracle 9i)

• Automatic Storage Management(ASM).

• Automatic Shared Memory Management(ASMM).

• Automatic Database Diagnostic Monitor(ADDM).

• Automatic Workload Repository(AWR).

• Flashback Technologies.

• Data Pump replaces Traditional EXP/IMP.

• Automatic Checkpoint Tunning(FAST_START_MTTR_TARGET).

• Automatic Undo Retention Tunning.

• Introduced Default Permanent Tablespace (USERS).

• Introduced SYSAUX tablespace.

• Streams Technology(STREAMS POOL).

• Introduced Big file Tablespace Option and Rename Tablespace Command.
• Automatic SQL Tunning.

• Temporary Tablespace Group and Default Temporary Tablespace.

• Recovery Manager Enhancements(RMAN).

• DBMS Scheduler Packages and DBMS File Transfer Packages.

The below Points are completely New in oracle database 11g

• Simplified and improved automatic memory management
• New fault diagnosability infrastructure to prevent, detect, diagnose, and help
  resolve critical database errors
• Invisible Indexes
• Virtual columns
• Enhanced security for password-based authentication by enabling use of mixed
  case in passwords.
• Tablespace-level encryption
• Ability to online redefine tables that have materialized view logs
• Be carefull with merge join cartesian explain plan
• Access Control List for accessing UTL_MAIL, UTL_SMTP, UTL_HTTP, UTL_TCP etc