Search

Top 60 Oracle Blogs

Recent comments

September 2014

12c In-Memory in PDB

In preparation for our upcoming 12c In-Memory Webcast @CaryMillsap, @TanelPoder, and I solicited questions from members of the universe at large on the interweb. We got a question about how In-Memory works with the 12c multi-tentant option and it got me thinking so I gave it a quick try. As it turns out, it works about as you would expect. The basic idea is to turn it on for the container DB (which is where the memory is actually allocated (ala the other main shared memory regions) and then decide which PDBs to allow to use it (and if so how much of it to use) or not. First, here are the steps necessary to allocate the memory in the container DB.

Good Blogs to follow

Good blogs keep popping up and other blogs fade into the back ground, so it’s hard to keep track of the good stuff out there. The following is a list of blogs I have either in the past gotten a lot out of or currently do. It would be great to get comments on what the best current blogs are and then iterate on this list and keep it updated.

There use to be a cool blog aggregator site called “collected.info” where I had aggregated a bunch of blogs but that site no longer seems to work and I’ve lost the list I built up there. There must be some new blog aggregator sites out there. Welcome suggestions.

The  Oaktable aggregates the blogs of its members, many list below, on it’s site oaktable.net.

 

Oracle Blogs

Unusual Deadlock

Prompted by a question on OTN I came up with a strategy for producing an ORA-00060 deadlock that DIDN’T produce a deadlock graph (because there isn’t one) and didn’t get reported in the alert log (at least, not when tested on 11.2.0.4). It’s a situation that shouldn’t arise in a production system because it’s doing the sorts of things that you shouldn’t do in a production system: but possibly if you’re trying to do some maintenance or upgrades while keeping the system live it could happen. Here’s the starting code:

Oracle Database 12.1.0.2.0 – Getting started with JSON Path Expressions

Yesterday my colleague Alex and I had the pleasure to do some extra presentations during AMIS’s Oracle OpenWorld preview evening. While still not getting around...
class="readmore">Read More

Embiggening the Marquee Menu Dots

The Marquee template on the Squarespace platform is wonderful with it's colorful images and parallax scrolling on index pages. It's one of my top two favorite templates. What's not so wonderful sometimes are those tiny dots in the parallax navigation menu at the right side of the browser window. 

The tiny targets in the parallax menu can be tough to hit with a mouse pointer, and a lot of detail or the wrong color in that right-side region can make the fly-out text tough to distinguish from the underlying image. What follows are a series of CSS mods by which you can bring some zest to that menu while making it into a larger and more legible target. 

Embiggening the Marquee Menu Dots

Building your Squarespace website in the Marquee template? Having trouble
seeing or clicking on those little dots that make up the parallax
navigation on the right side of your browser window?...



Read the full post at www.gennick.com/database.

inmemory: Why did that table was not populated in the column store?

I enabled an huge 70G table for inmemory population, I expected the inmemory population to take a while, but the population didn’t complete even after letting it run for a day. Why?

ASH data

Initial review of the server shows no issues, no resource starvation. This must be a problem with Oracle processes itself. I started digging further, and ASH data shows that in numerous samples the process was seen reading block using single block I/I calls. Also object_id matches with the table I was trying to populate.

inmemory: sa00 process

After the restart of a 12c inmemory database with 300GB+ SGA, I noticed that an Oracle background process sa00 was consuming a bit of CPU. Documentation suggests that it is SGA Allocator process, however, ipcs -ma command shows that the shared memory segment is already allocated. I was curious, of course, what would that background process will be allocating?.

pstack

Process stack of the process shows that it is touching SGA pages to pre-page SGA memory pages.

Inmemory: Not all inmemory_size is usable to store tables.

I have been testing the inmemory column store product extensively and the product is performing well for our workload. However, I learnt a bit more about inmemory column store and I will be blogging a few them here. BTW, I will be talking about internals of inmemory in Oaktable world presentation, if you are in the open world 2014, you can come and see my talk: http://www.oraclerealworld.com/oaktable-world/agenda/

inmemory_size

Can you have high redundancy files in a normal redundancy diskgroup?

One of the perks of teaching classes is that I get to research questions asked. In the last Exadata Administration Class I taught someone asked: can you have your disk groups in Exadata on normal redundancy yet have certain databases use high redundancy? This would be a good interview question …

The answer is yes, which I remembered from researching material on the 11g RAC book but I wanted to prove that it is the case.

Update: I planned a second blog post where I wanted to test the effect but Alex Fatkulin was quicker, and I promise I didn’t see his post when I wrote mine. Otherwise there probably wouldn’t have been one :) In summary, you aren’t really any better protected. The disk group remains at normal redundancy, even with the data files in high. Looking at Alex’s results (and I encourage you to do so) I concur with his summary that although you have a 3rd copy of the extent protecting you from corruption, you don’t have higher resilience.