Blog - comments

Thx helped us a lot, lsnrctl reload didn't help stop and start worked. Reconnect the SQL sessions b...
Laurens

Very useful article. Thanks Franck !

Krishna
Thanks a lot Franck. I agree to use FRA and RMAN deletion policy to manage standby site archived log...
RIck CHEN
I still say that you don't have to delete archivelogs because they are managed by oracle. That's the...
I don't know any documentation about those EC and ECJ. And I'm sorry I don't know the consequence of...
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.

 

Concept

Historically, the tables were stored in row format:

table_in_rows

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:

table_in_columns

 

In-Memory

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.

in_memory_storage

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;


Availability

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.

IMG_0460

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: https://www.surveymonkey.com/s/inmemorydatabase

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

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.

Comments

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

Leave your comment

Guest Friday, 28 November 2014
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Contact

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