Friday Jun 19, 2015

Star Schema Performance Challenge - Part 2

In my previous post, Star Schema Performance Challenge – Part 1, I outlined a challenge to support 100 concurrent users querying a 9 dimensional, 500 million row star schema using a Sun X4-4 (with 60 cores, 1 TB DRAM and commodity storage).  The users, of course, expect great query performance.  The challenging part of this is 100 active users on a 60 core machine.  With far fewer or less active users this might not be so challenging, but 100 users on this size machine is a different story.

In this post I’ll talk more about the workload and share some baseline results.

[Read More]

Monday Jun 15, 2015

SQL Plan Management

Have you ever upgraded something to a new version, like your phone or your laptop, and found that while most of it worked great there were just a few things that were worse or even broken? You might have decided to restore back to the previous version because the problem(s) were just too annoying or catastrophic to ignore. Well this was one of the motivations behind the release of SQL Plan Management back in Oracle Database 11g. SQL Plan Management (SPM) provides a framework for completely transparent, controlled execution plan evolution. The main idea being that your application should see no performance regressions due to execution plan changes when you upgrade or change something in your database environment.

[Read More]

Wednesday Jun 03, 2015

Oracle Database In-Memory Bundle Patch 8 Released

As most of you know, we are releasing regular bundle patches for Oracle Database In-Memory. These bundle patches are available periodically through My Oracle Support.

The latest bundle patch to be released was bundle patch 8 or 12.1.0.2.8 (DATABASE PATCH FOR ENGINEERED SYSTEMS AND DB IN-MEMORY 12.1.0.2.8). More information on the latest bundle patch can be found in the MOS note, Doc ID. 20879108.8 or 1937782.1.

The bundle patches are cumulative, which means bundle patch 8 includes all fixes from bundle patch 1 to 7 in addition to new content. Don't let the name of the bundle patch fool you. You can apply this bundle patch on non-engineered systems running Oracle Database In-Memory.

Going forward, we will keep you posted when a new bundle patch is released, so you will always know what is the latest bundle patch. We recommend that you always run with the latest bundle patch.

Friday Apr 24, 2015

In-Memory Priority

I'd like to thank everyone who attended our two Hands On Lab sessions at Collaborate last week. We had a great time presenting them and we received some really good feedback. One of the questions that came up, and gets asked periodically, is how does In-Memory priority really work?

Many times people have the misconception that the In-Memory priority attribute affects more than just the order of population but that’s not the case. The only thing the priority affects is the order of population at database startup. We discussed population briefly some time ago, but I think it's worth a quick review.

[Read More]

Tuesday Mar 31, 2015

Push-Down: Making Queries Fast!

In our previous posts we discussed the basic architecture of the In-Memory column store (IM column store) and now we want to drill down into some of the unique performance enhancing features. Push-down is one of the optimizations that makes scanning columns in the IM column store very efficient. Oracle Database In-Memory has the ability to push predicates, aggregations and group-bys down into the scan of a column or columns.  This ability to push-down allows us to take advantage of other performance enhancing features of Database In-Memory like SIMD vector processing and storage indexes.

[Read More]

Monday Oct 13, 2014

Getting started with Oracle Database In-Memory Part IV - Joins In The IM Column Store

It's been a while since I've had an opportunity to share a technical blog post but now that OpenWorld has wrapped up for another year it's time to get back to the techie details of Oracle Database In-Memory.

Up until now, we've focused on queries that scan only one table. Let’s broaden the scope of our investigation to include joins and parallel execution. In this post I'll show a series of queries that begin with a single join between a fact table, LINEORDER, and a dimension table DATE_DIM and work up to a multi-table join.

[Read More]

Thursday Oct 02, 2014

Day 5 of Oracle OpenWorld 2014 October 2nd

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.

We get the day started at 9:30AM with Top Five Things to Know About Oracle Database In-Memory (Session CON7248) in Moscone South - room 104. During this session, myself and several of the customers who have tested Oracle Database In-Memory will share our top tips for getting started with Oracle Database In-Memory and the best use cases. Don't forget we will have your last chance to win some In-Memory goodies in this session so come early and get a good seat! ;-)

Next up is Oracle Database In-Memory in Action (Session CON6812) at 10:45AM in Moscone South - room 104 presented by Kerry Osborne and Tanel Poder. In this session the lads will share some astounding performance results for real-time queries scanning multi-terabyte data sets in memory.

Then you have an opportunity to hear about two of my favorite subjects when the Optimizer development team presents Oracle Database In-Memory Meets the Oracle Optimizer (Session CON7639) at 12PM in Moscone South - room 102. This session explains in detail the enhancements made to the Oracle Optimizer to make it fully In-Memory aware.

We continue our roll, with How Oracle Database In-Memory Can Improve Performance in Financial Services (Session CON3924) at 1:15PM in Moscone South - room 102.

We finish up the technical sessions with Using the In-Memory Columnar Store to Perform Real-Time Analysis of CERN Data (Session CON4731) at 1:15PM in Moscone South - room 104, where you can hear about how Oracle Database In-Memory technology was used to help physicists at CERN analyze the data recorded by the experiments at the Large Hadron Collider.

Wednesday Oct 01, 2014

Day 4 of Oracle OpenWorld 2014 October 1st

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 9:45 am until 4pm. This maybe your last chance to snag an In-Memory bumper sticker!

There are also some great technical session on today, including:

  • Oracle Database In-Memory: Under the Hood (Session CON8367) at 2PM in Moscone South - room 104
    In this session, Tirthankar Lahiri, the VP of the In-Memory development, provdies an insiders view of the technology underlying Oracle Database In-Memory. He'll show how the novel in-memory dual format avoids the trade-offs inherent in single-format databases and enables both super fast analytics and online transaction processing (OLTP).

  • Oracle Database In-Memory Bootcamp (Session HOL9346) will take place at 4:15 PM in the Peninsula room at the Hotel Nikko. This hands-on lab provides 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.

  • Oracle Database In-Memory: How Do I Choose Which Tables to Use It For? (Session CON6558) at 4:45PM in Moscone South - room 305
    During this presentation, Christo Kutrovsky answers some of the most pressing questions customers have when they discover Oracle Database In-Memory such as 'How do you find which tables need In-Memory?'.

Tuesday Sep 30, 2014

Day 3 of Oracle OpenWorld 2014 September 30th

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

Today we give our second technical session, Top Five Things to Know About Oracle Database In-Memory (Session CON7248) at 12:00pm, in Moscone South - room 104.

In this session, I'll be joined by two of our customers who have first hand experiences with Oracle Database In-Memory. Together, we will explain in detail the top five things you need to know to get the most from Oracle Database In-Memory out of the box. We will also have some spot prizes to give away, so come early so you can get a good seat!

Then at 3:45pm Dr Holger Friedrich will present Oracle In-Memory: The Game Changer in Data Warehousing and Business Intelligence (Session CON5193) in Moscone South - room 102.

I'll also be presenting with @OraclePDB a.k.a Patrick Wheeler on  Oracle Multitenant Meets Oracle Database In-Memory (Session CON7306) at 5:45pm, in Moscone South - room 102.

And for all you night owls out there, today's Oracle Database In-Memory Bootcamp (Session HOL9346) will take place at 6:45 PM - 7:45 PM in the Peninsula room at the Hotel Nikko. Remember it's about a 15 minute walk from Moscone to the Hotel Nikko.

Monday Sep 29, 2014

Day 2 of Oracle OpenWorld 2014 September 29th

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 technical sessions or at the Oracle demogrounds.

Our first technical session, Oracle Database In-Memory: The Next Big Thing (Session CON8622) is on today at 1:30pm in Moscone South, room 103.

In this session, Juan Loaiza explains in detail what motivated Oracle to develop this new technology and provides a clear understanding of how this unique “dual format” architecture works. It also illustrates how the new in-memory functionality interacts with key database performance features such as Oracle Real Application Clusters (Oracle RAC), Oracle Partitioning, parallel execution, and much more.

Then at 4:15pm we'll host our first Oracle Database In-Memory Bootcamp (Session HOL9346) of the week in the Peninsula room 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 from 9:30am 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 Sep 28, 2014

Day 1 of Oracle OpenWorld 2014 September 28th

The biggest day of the Oracle calendar has arrived. Oracle Open World 2014 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 this one, which features Oracle Database In-Memory:

  • 3:30 PM - 4:15 PM 12 Looks at Oracle Database 12c - Part 2
    Session UGF9221 delivered by a host of great Oracle Ace speakers and yours truly in Moscone South - room 304

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

Tuesday Sep 02, 2014

Oracle OpenWorld 2014 - Time to plan your schedule

There is only one month to go until Oracle Open World, the largest gathering of Oracle customers, partners, developers, and technology enthusiasts, which begins on September 28th in San Francisco. Of course the In-Memory development group will be there and you will have multiple opportunities to meet the team, in one of our technical sessions, or at the Oracle demogrounds.

This year the In-Memory team has 4 technical sessions and there are a number of excellent customers sessions too;

[Read More]
About

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

Search

Categories
Archives
« July 2015
SunMonTueWedThuFriSat
   
1
2
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
       
Today