Monday Aug 04, 2014
Getting started with Oracle Database In-Memory Part II
By Maria Colgan on Aug 04, 2014
In part two of this series on getting started with Oracle Database In-Memory I’ll explain how and when objects are populated into the In-Memory column store (IM column store) and exactly how you can control it.
Which objects are populated into the IM column store?
As I mention last week, only objects with the INMEMORY attribute are populated into the IM column store. TheINMEMORY attribute can be specified on a tablespace, table, (sub)partition, or materialized view. In this example the INMEMORY attribute is specified on the CUSTOMERS.
[Read More]Monday Jul 28, 2014
Getting started with Oracle Database In-Memory Part I
By Maria Colgan on Jul 28, 2014
Now that Oracle Database 12.1.0.2 has been officially released, I can finally start sharing more technical details on how Oracle Database In-Memory (Database In-Memory) works.
I thought we should start this series of posts right at the very beginning by answering the question, how and when is Database In-Memory installed and enabled.
Let’s start by doing a clean install of 12.1.0.2 and allowing the installer to create a typical single instance database.
[Read More]Tuesday Jul 22, 2014
It's here! Oracle Database In-Memory is officially released
By Maria Colgan on Jul 22, 2014
Oracle Database 12.1.0.2 was officially release today and is now available for download, which mean Oracle Database In-Memory is officially here!
Along with the software release comes a whole new set of collateral that explains in detail how all of the new Oracle Database In-Memory functionality works. The In-Memory page on Oracle.com has all of the juicy details including the official whitepaper.
[Read More]Monday Jul 14, 2014
In-Memory Column Store versus the Buffer Cache
By Maria Colgan on Jul 14, 2014
In this week's blog post I'm going to address just one question. It's actually the question I have gotten the most since I started blogging on Oracle Database In-Memory.
Why does In-Memory populate complete tables or partitions into memory instead of caching frequently accessed blocks like the buffer cache?
[Read More]Sunday Jul 06, 2014
Oracle Database In-Memory & the Optimizer
By Maria Colgan on Jul 06, 2014
As we continue our series of Q&A style blogs on Oracle Database In-Memory, I've got a chance to go back to my old life as the optimizer lady as I've been inundated with questions about the In-Memory option and the Optimizer.
Below are the answers to the questions I gotten so far.
If there is something else you want to know about how these two fascinating pieces of the Oracle technology work together just email me and I will include it in an upcoming post.
Is there a new Optimizer to deal with queries against the In-Memory column store?
[Read More]Wednesday Jun 25, 2014
Oracle Database In-Memory Population
By Maria Colgan on Jun 25, 2014
Thanks to all those who have sent me questions on the new Oracle Database In-Memory. Below are the answers to some of the questions you have sent. Don't worry if you don't see the answer to your question in this particular blog post, as there has been a huge interest and a lot of questions!
I have grouped the questions into categories and will publish a different category every couple of days for the next few weeks. In this post I focus on questions around the population of the In-Memory column store (IM column store).
[Read More]I have grouped the questions into categories and will publish a different category every couple of days for the next few weeks. In this post I focus on questions around the population of the In-Memory column store (IM column store).
Wednesday Jun 18, 2014
Oracle Database In-Memory Launch!
By Maria Colgan on Jun 18, 2014
On Tuesday, June 10th, Larry Ellison officially launch the new Oracle Database In-Memory option, which means we can finally start blogging about it!
I have spent this week on the road participating in launch events all over Europe and have gotten a lot of question about the In-Memory option and how it works. So, I thought it would be a good idea to begin our In-Memory blog with the answers to some of the most commonly asked questions about Oracle Database In-Memory.
[Read More]Sunday Feb 16, 2014
Preview the Oracle Database In-Memory option
By Maria Colgan on Feb 16, 2014
At Oracle Open World 2013 Larry Ellison announced the upcoming availability of Oracle Database In-Memory, a solution for accelerating database-driven business decision-making to real-time. Unlike specialized approaches that are restricted to particular workloads or applications, Oracle leverages a new In-Memory Column Store format to speed up analytics.
But how does it work? What performance improvements can you expect? How do you enable it?
[Read More]
