---
title: The differences between Oracle Database 9i, 10g,11g and 12c
description: With Oracle Database 9i and 10g now both out of support, you should be thinking about an Oracle Database Upgrade to Oracle 11g or 12c?
---

[DSP Blog ](https://content.dsp.co.uk)

# [The differences between Oracle Database 9i, 10g,11g and 12c](https://content.dsp.co.uk/the-differences-between-oracle-database-9i-10g11g-and-12c)

 Written by [Jon Cowling](https://content.dsp.co.uk/author/jon-cowling) | 08-Feb-2016 14:23:04

# The differences between Oracle Database 9i, 10g,11g and 12c

With [Oracle Database](https://www.dsp.co.uk/oracle-support) 9i and 10g now both out of support, you should be thinking about an Oracle Database Upgrade to Oracle 11g or 12c?

With each release there is is always improvements and new features.

Here are some key features of Oracle Database 9i, 10g and 11g;

| **Oracle 9i** | **Oracle10g** | **Oracle11g** |
| --- | --- | --- |
| **RAC** **Introduced** -      Providing High availability | **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 Database Comparison

DSP have extensive experience across all Oracle database versions, Oracle Database upgrades and [Oracle Database consultancy](https://www.dsp.co.uk/oracle-database-consultancy).

## Oracle Database 12c - what is new?

There are a host of new features that are now available with Oracle database 12c, including multitenant architecture which enables you to run pluggable databases in a multitenant container database. There are also many improvements in areas such as Big Data, Data security and Storage optimisation, which are key areas which will help drive future business growth.

More information on Oracle12c can be downloaded [here](https://www.dsp.co.uk/pdf/12c-new-features.pdf).

If you are interested in upgrading your [Oracle database](https://www.dsp.co.uk/oracle-database-support) please contact DSP at [enquiries@dsp.co.uk](mailto:enquiries@dsp.co.uk)

[View full post](https://content.dsp.co.uk/the-differences-between-oracle-database-9i-10g11g-and-12c)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Jon Cowling"
  },
  "dateModified" : "2025-03-06T15:28:03.078Z",
  "datePublished" : "2016-02-08T14:23:04Z",
  "headline" : "The differences between Oracle Database 9i, 10g,11g and 12c",
  "image" : {
    "@type" : "ImageObject",
    "height" : 727,
    "url" : "https://content.dsp.co.uk/hubfs/Stock%20images/row%20of%20light%20bulbs%20with%20one%20different%20from%20the%20others.jpeg",
    "width" : 1000
  },
  "mainEntityOfPage" : "https://content.dsp.co.uk/the-differences-between-oracle-database-9i-10g11g-and-12c",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60.0,
      "url" : "https://content.dsp.co.uk/hubfs/Logos/DSP/DSP-logo-2019-150px.png",
      "width" : 58.44156
    },
    "name" : "DSP Blog"
  }
}
```