Friday Nov 20, 2015

Questions You Asked: What happens to a table In-Memory if one of my RAC nodes goes down?

We’ve written a number of blog posts on how Database In-Memory behaves in a RAC environment but recently we’ve gotten a lot of questions regarding what happens if one of the RAC nodes should fail. So, I thought I would try tackle this question and point out a couple of other interesting aspects of running Database In-Memory on RAC in this post.

Quick Recap

If you recall from part 1 of our RAC series each RAC node has it’s own In-Memory column store (IM column store). When a table is populated into memory in a RAC environment it will be distributed across all of the IM column stores in the cluster. That is to say, a piece of the table will appear in each RAC node.

Let’s take a look at an example using the LINEORDER table, which has 5 million rows in it and is approximately 550MB in size on my 3 node RAC cluster.

[Read More]

Friday Nov 13, 2015

Questions You Asked: When using interval partitioning, will new partitions be placed In-Memory?

This is the second in our series of "Questions You Asked" and this time the question has to do with interval partitioning and whether newly created partitions will be populated into the IM column store.

We'll begin our experiment by creating an interval partitioned table based on the SUPPLIER table from our SSB schema. I've added a key_no column to make the interval partitioning easy. We then insert data into three partitions and list the results. Note that the first partition is named p1 because we had to create at least one partition with our CREATE TABLE statement. The other two are system generated names and those partitions were created automatically as part of the interval partitioning feature when we ran the second and third insert statements as you can see below.

[Read More]

Friday Nov 06, 2015

Oracle OpenWorld 2015 Wrap up!

I can't believe another Oracle OpenWorld has been and gone.

Thanks to all those that attended the In-Memory sessions and stopped by the In-Memory demopod during this years Oracle OpenWorld. It was an amazing conference this year with lots of great technical sessions and interesting discussion at the demo grounds.

I've been inundated with requests to share the presentation we gave on In-Memory at the conference, so I thought it would be a good idea to share the links to the presentations here.

A number of Oracle Database In-Memory customers present on their experiences of using In-Memory. You can find details from their sessions below;

We also gave folks the opportunity to try out Oracle Database In-Memory for themselves in our hands-on lab, Oracle Database In-Memory Option Boot Camp: Everything You Need to Know, so I thought I would share the lab handbook in case anyone want to try some of the labs at home.

Finally there was a lot of talk about how Oracle Database In-Memory takes advantage of Software in Silicon ,so I thought it would be good to share this link to a short video of Juan Loaiza describing exactly what we mean by Software in Silicon.

We hope you enjoyed the conference as much as we did and we look forward to see you all again next year at OOW 2016 September 18–22, 2016 in San Francisco.

Thursday Oct 29, 2015

Day 5 of Oracle OpenWorld 2015 October 29th

It's the last day of Oracle OpenWorld and we have saved the very best for last. So hopefully you are still awake and functioning after the party!

Today, we have a fantastic line up of In-Memory sessions, so grab your coffee and start your last day at our hands-on-lab Oracle Database In-Memory Bootcamp (Session HOL10483) at the slightly later time of 9:30am in the Golden Gate room (25th Floor) at the Hotel Nikko.

If you have already attended our hands on lab, check out our last Database In-Memory technical session Introducing Analytic Views—Bringing Star Queries into the Twenty-First Century (Session CON8742) at 9:30am in Moscone South - room 309. During this session Bud Endress will introduce Analytic Views and describe how they easily transform tables into the next-generation data source for BI applications and Excel Pivot Tables.

Before you head for the airport, don't forget to stop by the Engineered System Showcase to check out the Database In-Memory demo and pick up both an In-Memory bumper sticker and a SQL in Silicon sticker.

We hope you have a safe trip home and we will see you all again next year, when we will have even more great session on Oracle Database In-Memory!

Wednesday Oct 28, 2015

Day 4 of Oracle OpenWorld 2015 October 28th

Thanks to all those who stopped by the demogrounds to chat with the In-Memory developers over the last two days. Remember, today is the last day of the demogrounds, so if you haven't had a chance to stop by yet, do so today. The In-Memory developers will be there from 10:00am until 4pm. This may be your last chance to snag an In-Memory bumper sticker, so don't miss out!

But before you head to the demogrounds why not start your day at our hands-on-lab Oracle Database In-Memory Bootcamp (Session HOL10483) in the Golden Gate room (25th Floor) at the Hotel Nikko. The fun begins bright and early at 8:45 am!

There are also some great technical sessions on today, including your first opportunity to ask questions of production Oracle Database In-Memory customers and see if the technology lives up to the hype. I will be hosting our first Oracle Database In-Memory Customer Panel (Session CON8657) at 1:45pm in Moscone South - room 103. The session will begin with each customer briefly sharing how they are using Oracle Database In-Memory before we dive into an open discussion. I strongly encouraged you to actively participate in this session and pose any questions you may have about Database In-Memory and other alternative solutions considered by the panelists.

Then in the afternoon we have our last customer session on Database In-Memory given by General Mills, How Exadata & Database In-Memory Power Precision Marketing at General Mills (Session CON4292) at 3:00pm in Moscone South - room 254. Mark and Josh from General Mills explain how Oracle Exadata with Oracle Database In-Memory gave them a scalable and reliable platform from which to build a consumer-first data warehouse.

Finally before you rush off to put on your dancing shoes for the appreciation event, we have another great technical session, Oracle Database In-Memory: Under the Hood (Session CON8652) at 4:15pm in Moscone South - room 103 where Tirthankar Lahiri, the VP of Database In-Memory development, will provide an insiders view of the technology underlying Oracle Database In-Memory and give you a sneak peek at what you can expect from Oracle Database In-Memory in our next generation!

Tuesday Oct 27, 2015

Day 3 of Oracle OpenWorld 2015 October 27th

Hopefully you enjoyed yesterday, the first full day of technical sessions at Oracle OpenWorld, and are ready for more today!

First thing this morning at 8:45 am is your second opportunity to attend our hands-on-lab, Oracle Database In-Memory Bootcamp (Session HOL10483) in the Golden Gate room (25th Floor) at the Hotel Nikko. I know it's early but trust me it will be a great way to start your day as it will leave you inspired and energized!

Today we will also give our first two technical sessions. First up is  Best Practices for Getting Started with Oracle Database In-Memory (Session CON6775) at 11:00am, in Moscone South - room 104.

In this session, I'll provide you with a step-by-step guide on how to get started with Oracle Database In-Memory, including advice on when and where you should take advantage of Oracle Database In-Memory. I'll also outlines strategies to help ensure that you get the promised performance boost regardless of your database environment. If you do come to this session, be sure to keep an eye out for this little fellow, as he will be on top of all of the slides with the top tips!

Later in the day we have our 3rd customer session when Dan Huls from AT&T WiFi presents, Oracle Database In-Memory: A Practical Solution (Session CON3087) at 4pm in Moscone South - room 307. Dan will share with you how they implemented Oracle Database In-Memory on a large customer-facing data warehousing system in under two months with little or no changes to their application. He will also provide details on why they chose Oracle Database In-Memory versus a more expensive SAP HANA solution.

Finally Juan Loaiza, EVP of Database Development, will present Oracle Database In-Memory—What’s New and What’s Coming (Session CON8659) at 5:15pm in Moscone South— room 103. In this session Juan will explain in detail what motivated Oracle to develop this new technology and provides a clear understanding of how this unique “dual format” architecture works. He will also give you a sneak preview of what to expect next for Database In-Memory. A definite must see session!

Monday Oct 26, 2015

Day 2 of Oracle OpenWorld 2015 October 26th

Oracle OpenWorld started yesterday and San Francisco is just buzzing with Oracle folks.

If you are attending the conference don't miss the opportunity to chat with the Oracle Database In-Memory team at one of our sessions or at the Oracle demogrounds.

Today kicks off with one of the best general sessions of the conference, General Session: Next-Generation Data Management Architecture Session GEN6765 at 11am in Marriott Marquis—Salon 7/8/9 (Yerba Buena Ballroom) in which Andy Mendelsohn, EVP of Database development, will share how Oracle Database 12c and its next-generation architecture are helping customers on their journey to the cloud.

Then in the afternoon the first 2 of the 8 customers speaking about their experiences with Oracle Database In-Memory will have their sessions. First up is Facebook’s Use of Oracle Database In-Memory from Inception to Rollout Session CON1685 at 2:45pm in Moscone South - room 301. Sudhi Vijayakumar will describe how Facebook evaluated Oracle Database In-Memory and then rolled it out in production to reap the benefits of faster response times for analytical queries.

Then at 4:00pm Five Ways Swiss Mobiliar Improved Business Value with Database In-Memory Session CON2715 in Moscone South - room 310. In this session folks from Swiss Mobiliar explain how they extended their traditional business intelligence (BI) systems to a more real-time solution using Oracle Database In-Memory. They will also compare this new solution to their original IBM DB2 solution.

Today is also your first chance to catch our hands-on-lab, Oracle Database In-Memory Bootcamp (Session HOL10483) in the Golden Gate room (25th Floor) at the Hotel Nikko. In this hands-on lab we'll provide a step-by-step guide on how to get started with Oracle Database In-Memory, how to identify which of the optimizations are being used, and how your SQL statements benefit from them. You will also get to experience firsthand just how easy it is to start taking advantage of this technology and the incredible performance improvements it has to offer.

Remember it's about a 15 minute walk from Moscone to the Hotel Nikko, so make sure you give yourself plenty of time to get there.

Members of the In-Memory team will also be available at booth SLD 28 from 10:00am to 6pm at the Oracle Database demogrounds in Moscone South, to answer any questions you might have. Remember the In-Memory demo booth is the best place to snag a limited edition In-Memory bumper sticker!

Sunday Oct 25, 2015

Day 1 of Oracle OpenWorld 2015 October 25th

The biggest week of the Oracle calendar has arrived. Oracle Open World 2015 officially starts today and it's going to be a fantastic conference for anyone interested in Oracle Database In-Memory. We have tons of great sessions planned for you, as well as hands on labs and of course plenty of opportunities to talk directly with the In-Memory development team.

The show kicks off with tons of great technical sessions today, selected by the Oracle User Groups, including the following sessions, which feature Oracle Database In-Memory:

  • Eighteen Months of Production Experience with Oracle Database 12c at CERN Session UGF 6827 at 9:00 am in Moscone South - room 306. Eric Grancher and Prasanth Kothuri from CERN share the reasons why they decided to become early adopters of Oracle Database 12c  and their experiences both during the migration and also now that they have been in production for over a year.

  • Oracle Database In-Memory Option: Challenges and Possibilities Session UGF10319 at 11:00 am in Moscone South - room 262. Christian Antognini explains the key concepts of Oracle Database In-Memory option, reviews what to expect from this new technology, and looks at situations in which the user can take advantage of it.

  • More Than Another 12 on Oracle Database 12c Session UGF 3190 at 1:30pm in Moscone South - room 306. In this session twelve of the best speakers in EMEA—all ACE directors— and little old me will share our knowledge on Oracle Database 12c. Quick-fire, seven-minute topics provide nuggets of wisdom to consider and explore during and after Oracle OpenWorld. A must attend session if you love different accents!

And of course, Larry's keynote is this evening from 5:00pm – 7:00pm, Moscone North. A must see, as he is bound to make some exciting announcements to get the show started!

Tuesday Oct 13, 2015

Star Schema Challenge - Part 5

In my previous post I established a baseline for 100 concurrent users running a variety of business intelligence queries against a 500 million row star schema on a commodity Intel-based server with 60 cores and 1 TB of DRAM.  All tables were loaded in the In-Memory column store (IM column store). 

At 100 users, the star schema ran at a median of 21.5 seconds per query and the de-normalized fact table ran at a median of 10.0 seconds per query. Given that this test runs 100 users on a 60-core server, it should be obvious that it is asking a lot of the server.  With 25 users the star ran at a median of 3.85 seconds and the de-normalized table ran at median of 1.57 seconds per query, an excellent result for this more reasonable workload. 

[Read More]

Friday Oct 02, 2015

Questions you asked: What happens if a column is not In-Memory?

When we're talking to customers or giving presentations questions often get asked that seem simple, but could have an answer that is worth showing with an example rather than just saying, "yes, it works this way". So I'm going to start a series of posts that will address those questions. I will continue the series as I come across what I think are interesting questions.

This first post in the series of "Questions You Asked" will be "What happens if a column is not In-Memory?"

[Read More]

Saturday Sep 12, 2015

Oracle Open World 2015 Time to plan your schedule!

There are only 6 weeks to go until Oracle Open World, the largest gathering of Oracle customers, partners, developers, and technology enthusiasts, which begins on October 25th in San Francisco.

Of course the In-Memory development group will be there and you will have multiple opportunities to meet up with us, in one of our technical sessions, our hands-on-labs or at the Oracle demogrounds.

This year the In-Memory team has 4 technical sessions and there are also 5 excellent customer sessions you shouldn't miss.

[Read More]

Monday Sep 07, 2015

Star Schema Challenge - Part 4

In my previous post Star Schema Challenge - Part 3, I reported the first of the in-memory performance results with 25 users querying the star schema in the In-Memory column store (IM column store). In Star Schema Challenge - Part 3.1 I did the same for the de-normalized fact table in the IM column store.  This serves as a comparison between the row format in-memory (buffer cache) and IM column store. For this comparison I stopped at 25 users because it became clear this was enough users for the row store table.  Now it is time to start working towards 100 concurrent users.

[Read More]

Friday Aug 28, 2015

Popular Statistics with Database In-Memory

Throughout our previous posts we have mentioned various session level statistics that are available to help identify what is actually going on with Database In-Memory. Since these statistic definitions didn't make it into the Reference manual I was asked recently if there is a list anywhere that defines what these statistics are. Since there isn't I thought I'd post a summary of the popular statistics that we've mentioned in the blog and that you might want to know about.

[Read More]

Friday Aug 21, 2015

Understanding new In-Memory notes in an execution plan

If you have started to play around with Database In-Memory, chances are you have been examining execution plans to see if the optimizer has chosen to use the In-Memory column store (IM column store) or not. In addition to the execution plan itself, you should also check out the NOTE section under the plan, which contains more information about how a query was executed, such as if dynamic sampling was used during the query optimization.

[Read More]

Friday Aug 14, 2015

Star Schema Challenge - Part 3.1

In my previous post (Star Schema Challenge – Part 3) I revealed the first of the Database In-Memory results, 25 users querying a 500 million row star schema with tables in the In-Memory column store(IM column store) on a commodity Intel-based server with 60 cores and 1TB of DRAM.

In this post I will reveal the first of the in-memory results for the de-normalized version of the fact table.

[Read More]

The Oracle Database In-Memory blog is written by the Oracle product management team and sheds light on all things In-Memory.


« November 2015