Friday May 08, 2015

Getting started with Oracle Database In-Memory Part V - Controlling Access

I’m finally going to make good on a promise I made way back in part 3 of our getting started with In-Memory series, to explain how you could control which queries use the In-Memory column store (IM column store) and which don't.

As with all new query performances enhancing features in the Oracle Database, a number of initialization parameters and hints have been introduce that enable you to control when and how the IM column store will be used. This post provides information on the initialization parameter, while the details on the Optimizer hint that control the use of the IM column store can be found on the Optimizer blog.

[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]

Sunday Aug 17, 2014

Getting started with Oracle Database In-Memory Part III - Querying The IM Column Store

In my previous blog posts, I described how to install, enable, and populate the In-Memory column store (IM column store). This week's post focuses on how data is accessed within the IM column store.

Let’s take a simple query “What is the most expensive air-mail order we have received to date?”

SELECT Max(lo_ordtotalprice) most_expensive_order
FROM lineorder

WHERE
lo_shipmode = 5;

[Read More]

Monday Aug 04, 2014

Getting started with Oracle Database In-Memory Part II - In-Memory Population

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. The INMEMORY 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 - Installing & Enabling

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]
About

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

Search

Archives
« August 2015
SunMonTueWedThuFriSat
      
1
2
3
6
7
8
9
10
11
12
13
15
16
17
18
19
20
22
23
24
25
26
27
29
30
31
     
Today