| 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 |
