Differnces between 9i,10g,11g databases

Differnces between 9i,10g,11g:

===================

        9i: The improvement in Oracle 9i aims at improved optimization of     conventional business applications:

        1: System fault recovery

          2: Disaster recovery

          3: online changes in schema

          4: Flashback Query

          10g: There are several hundred feature differences between the 9i     and 10g versions:

   1: Oracle Enterprise Manager (OEM) in 10g completely redesigned

    2: The imp utility on the Data Pump has been replaced with impdp

    3: Automatic Database Diagnostic Monitor (ADDM)

    4: introduced Automatic Storage Management (ASM)

    5: Scheduling package dbms_job is replaced by    the dbms_scheduler package

    6: Introduction of backup compression by RMAN

     11g: The design of  11g implemented this through creation of automated storage, automated memory management and creation of intelligent         tuning advisors.

    1: Automatic memory tuning

    2: Automated load balancing in storage

    3: Automated Diagnostic Repository

    4: Load balancing utilities

    5: File group repository