Differences between Various Oracle Database Versions

 

Oracle 9i

Oracle10g

Oracle11g

RAC Introduced

–      Providing High avaliability

RAC Improvements

–       improved clusterware

–       Introduction of VIP’s for RAC

Further RAC Improvements

–       Faster failover of services

–       Grid Plug&Play allowing seamless additions/removal of nodes

DataGuard enhancements

–      Detection of gasps and automatic resolution

DataGuard improvements

–       Realtime apply and log compressions

–      Fast start failover added

Active DataGuard added

–       Standby Database can now be queried whilst redo apply is active

Backup and Recovery

–       Block level recovery

–      Improved reporting and automation

Data Pump added

–      Extract and import data faster than ever

Improved Manageability

–       ASM Cluster FileSystem (ACFS) Introduced

–      Virtual Columns added

 

 

Oracle 11g

Oracle 12c

Varchar 2 Size

max 4K

max 32K

Multiple Indexes on a Single Column

max 1

a column can be part of multiple index

Pluggable Database

NA

Available

In-Memory Column Store

Data Buffer was available

IM Column Store along with DB Cache

Data Pump Support for the In-Memory Column Store

NA

Available

Force full database caching mode

NA

Available

Oracle Multitenant option

NA

Available

Full transportable export/import

NA

Available

Target Enviroment

Grid

Cloud