Tuesday May 03, 2016

New Technical Briefs

We've added a new Technical Briefs section to the blog. If you scroll down on the blog you will see a new section titled "Technical Briefs" on the right hand side.


One of the briefs is an update for Oracle Database 12c on how to create SQL Monitor active reports and the other describes how to create an Optimizer trace file. Hopefully you will find these useful quick references.

Monday Apr 18, 2016

Why does BYTES_NOT_POPULATED suddenly show a non-zero value?

I recently got a question from a customer who has just begun adopting Database In-Memory and thought it was worth answering as a blog post in case anyone else had encountered the same scenario and was wondering what was going on.

Here is the question I got:

“I've observed a scenario where a table is fully populated in the In-Memory column store with 0 in the  BYTES_NOT_POPULATED column in v$im_segments, but after some time, the BYTES_NOT_POPULATED column shows a non-zero value. Why is Oracle purging part of my table from memory?”

Let me begin to answer this by assuring you all that Oracle does not purge your data out of the In-Memory column store.

[Read More]

Monday Apr 11, 2016

Oracle OpenWorld 2016 call for papers has begun!

Believe it or not, it's time to start thinking about Oracle OpenWorld 2016!

The Oracle OpenWorld 2016 call for papers is now opens! Oracle customers and partners are encouraged to submit proposals to present at this year's Oracle OpenWorld conference, which will be held September 18 - 22, 2016 at the Moscone Center in San Francisco. Details and submission guidelines are available on the Oracle OpenWorld Call for Papers web site. The deadline for submissions is Friday,  May 9, 11:59 p.m. PDT.

We look forward to checking out your sessions on Oracle Database In-Memory and how it has changed the way you do business!

Friday Mar 25, 2016

Why didn't Database In-Memory improve the performance of my query?

After I posted last weeks blog post on identifying analytic queries that benefit from Database In-Memory, I got the following question, Why didn't Database In-Memory improve the performance of my query?"

I've simplified the query in question down to the following,

SELECT Count(DISTINCT cust_id)
FROM ssh.sales
WHERE amount_sold > 1;

So, why didn’t Database In-Memory improve the performance of this query?

[Read More]

Friday Mar 18, 2016

How do I identify analytic queries that will benefit from Database In-Memory?

Although Database In-Memory can be used in both Enterprise OLTP systems and Data Warehouses, only analytic queries will benefit from accessing data from the In-Memory column store (IM column store). Remember the IM column store enables large volumes of data to be rapidly scanned and processed using a variety of optimizations. Simpler transaction based queries, such as a primary key look up do not benefit from the IM column store and are automatically directed to the buffer cache.

But how do you identify an analytic query?

An analytic query is one where a large amount of data is scanned and filtered to return critical data that drives better business decisions. It doesn’t necessarily mean a query that contains one of Oracle’s analytical functions but they can also see benefits. A star query is a good example of such a query. By star query, I mean a query where a large fact table (center of the star) is joined to a number of smaller dimension tables (the points of the star).


If you don’t have a simple star schema (most people don’t) then you can identify a good candidate query by examining some key characteristics.

[Read More]

Monday Mar 14, 2016

Oracle Database In-Memory at Collaborate 16 in Las Vegas

Andy Rivenes (@TheInMemoryGuy) from the Oracle Database In-Memory team will be presenting two hands-on-labs and will be co-presenting a session at this year's IOUG Collaborate 16 conference, in Las Vegas April 10 - 14. Below are details on the sessions he will be presenting. We hope that you have an opportunity to check out some of these sessions if you plan to attend the event!

[Read More]

Saturday Feb 20, 2016

What is an In-Memory Compression Unit (IMCU)?

In our previous blog series "Getting Started", we described how the In-Memory column store (IM column store) is part of the System Global Area (SGA) and is allocated at instance startup by setting the initialization parameter inmemory_size. For the purposes of this blog entry we have a 12.1.0.2 database running with an 800MB inmemory_size and an sga_target of 3008MB:


This results in the following SGA allocation:


What we didn’t explain was that the IM column store is actually divided into two pools, a 1MB pool and a 64KB pool.

[Read More]

Friday Feb 12, 2016

How do I limit the amount of memory each PDB can use in the IM column store?

In case you aren’t familiar with what a PDB is, let me begin by explaining what a Multitenant environment is and how PDBs fit into it.

Oracle Multitenant is a new database consolidation model in Oracle Database 12c in which multiple Pluggable Databases (PDBs) are consolidated within a single Container Database (CDB). While keeping many of the isolation aspects of single databases, Oracle Multitenant allows PDBs to share the system global area (SGA) and background processes of a common CDB.


When used with Oracle Database In-Memory, PDBs also share a single In-Memory column store (IM column store) and hence the question, "How do I control how much memory each PDB can use in the IM column store?"

[Read More]

Friday Nov 20, 2015

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!

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
« May 2016
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