Oracle 12c In-Memory

On June 10 2014 Larry Ellison CEO of Oracle Announced the the new 12c “in-memory” feature.

The following is highlights summary:

  • The 12c feature will be available for the public in July 2014.
  • 12c In-Memory can be installed and will be transparent to application (no changes required).

  • One of the primary goals for Oracle with in-memory database is to increase the performance for both Queries and Transactions.

  • Both Row and Column formats are used in 12c Database (Column is for Analytics).

  • Indexes being removed will speed up OLTP while using mixed column formats in 12c in-memory.

  • In-memory option can be used in EXADATA with Real-Application Clusters (multiple nodes).

  • Only “Active data” are being resided in memory (hosted on Flash or DRAM) and cold data will be residing on Disk. This approach is better in efficiency and economic (since most data will be residing on low cost disks).

  • High Availability:Backup/Recoverability/Manageability remains the same no changes is required.

 

  • Fault Tolerance:

    *Similar to storage mirroring

         * Duplicate in-memory columns on another node, this will lead to downtime elimination bys using the other  duplicate after failure.

Youtube Link:

http://www.youtube.com/watch?v=dZO1CD8VgY0

Oracle in-Memory Vs. SAP HANA:

http://www.oracle.com/technetwork/database/options/dbim-vs-sap-hana-2215625.pdf?ssSourceSiteId=ocomen

Image

This feature looks promising 😉

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s