Blog - comments

Hi Stephane,

In fact at dbi services we have professional material ;-)

Samsung SSD 840 PRO Series

Gregory Steulet

I have a write throughput 10x lower than your test (is it the SSD?)

stephane (ebu)
You obtained :Running the test with following options: Number of threads: 64 Random number generator...
stephane (ebu)

I wrote a benchmark based on your own. I'm so far from your result (which is very good for a laptop)

stephane (ebu)
Hi Stephane,It depends, you can find the stats for MySQL 5.6 below:sysbench 0.5: multi-threaded sys...
Gregory Steulet
Blog Nicolas Jardot Oracle Open World 2013: Day 4 - In-Memory, the next big thing in Oracle 12c

dbi services Blog

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
Posted by on in Technology Survey

Oracle Open World 2013: Day 4 - In-Memory, the next big thing in Oracle 12c

Let's talk about the 4th day in San Francisco at Oracle OpenWorld 2013. Many conferences, hands on labs, keynotes and so on. Some sessions are in the biggest room with many people. Today, we will focus on the new In-Memory option. I have already posted about that feature, but today, I went to an In-Memory session to get a little more details on it - many pictures and less text (easier to gigest ;-).

Larry Ellison has announced the In-Memory option during the opening Keynote and he presented an impressive demo with a speed improvement of over 1300 times.



Historically, the tables were stored in row format:


It's really efficient to manipulate a few rows when we need to access almost all columns (during insert for example). That's why, Larry told us, it's the best format for OLTP transactions. In OLTP, we work mainly with rows (add, change or remove).

Currently, many databases have OLTP activity and reporting activities at the same time. In reporting, we are focused on columns, we take all rows regarding a specific filter and we join to another table filtered also on a column.

A new format has been discussed for that purpose - storing the table in columns:




The column format is a totally new in Oracle and will exist only in memory. It will coexist with the row format and should never interfere with all regular operation regarding availability. RMAN, Data Guard or Golden Gate will not be impacted by that new format for backup or data replication because on disk, only one format will be saved and it's the same as before.


The columns will be stored using a compression algorithm but in a different way as HCC (Hybrid Columnar Expression) because it focuses on performance. The optimizer will have a new task, it will decide which format will be used to get the data for all queries. Before, scanning all tables to read a column was a long operation. With In-Memory, it will become faster than using an index.

The new format will also be available in the next release of Oracle TimesTen In-Memory Database.

The key point for Oracle Database 12c is that the database will work in a hybrid mode, not all database will reside in memory, data can be accessed on disk or on flash drives.

So, what happens in case of a crash? There is no need to wait for objects to be loaded In-Memory before starting operations. Data will be accessed from disk until the objects are present in memory unlike a full In-Memory database.


How do I activate In-Memory?

The core message from Oracle is that there is no need to update the application. And more, the new format will replace what they call "analytic indexes", created to speed up some statements.

The new option will be enabled with a single init parameter:


alter system set inmemory_area = XXX GB


Then, you just need to tell Oracle which table should be loaded In-Memory:


alter table/partition inmemory;


The In-Memory option will be available next year, but we cannot have more details yet.


Some tests

The demo presented during the opening keynote is not a fake. Oracle OpenWorld visitors in San Francisco were able to have a look at the Engineered System booth to test it in live.


If you are interested on this new option, Oracle has put a survey online. Feel free to fill in that survey using the following link:

I hope I will be soon be able to test this feature to have a deeper look at its strengths and weaknesses.

Rate this blog entry:

Nicolas Jardot has more than two years of experience in Oracle database management and Microsoft application development. He is specialized in Oracle tuning as well as in the Oracle Optimizer. Nicolas Jardot perfectly masters the behavior of the Oracle Optimizer, holding speeches on the topic at the Oracle OpenWorld 2013 and the UKOUG 2013. He is also specialized in C++ development and masters the programming of requests in SQL language. Nicolas Jardot has a solid experience in the virtualization and centralization of applications. He has developed several PL/SQL packages aimed to simplify the administration of database applications and maintains the DMK_SQL package of dbi services' Database Management Kit. Nicolas Jardot is Oracle Certified Professional 11g (OCP 11g) and ITIL Foundation V3 certified. He holds an Engineer's Degree in Computer Science from the University of Technology of Belfort-Montbéliard (F). His branch-related experience covers Pharma, Public Sector, Health, Real Estate, Automotive, etc.


  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Friday, 31 July 2015
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)


Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter