Free Oracle event with beer: London 3/7/2014

A quick note to drum up interest in a free Oracle event being hosted by e-dba in London on the evening of 3rd July 2014.

The aim is to have a series of informal get togethers over beer, pizza and some good Oracle speakers.

The theme of the first event is based around upgrading.

We have Jonathan Lewis presenting on general principles and strategies for upgrading the RDBMS.

I will be doing a couple of live demos including an in place 12c upgrade in 15 minutes and hopefully showing how to migrate from an 11gR2 database to a new 12c pluggable database with a full transportable datapump import – a new migration method for 12c.

Not to mention the discussion on Swingbench and SLOB.

Did I mention the free beer?

Hope to see you there.


Oracle ASM 12c: New Features

Last week I was lucky enough to be presenting at the UKOUG AIM SIG. There was a decent enough crowd in attendance and there were some really interesting talks and some really good speakers. In particularly I found Chris Lawless speaking on replication a particularly engaging speaker, and Dave Webster really held the audiences attention late in day.

I was giving a presentation on the new features available to you with 12c ASM. The presentation is below. What you don’t get from the ppt, though is the various demos I did, and in particular seeing flex ASM in action on my 4-node 12c RAC demo cluster.

I should confess, the above isn’t quite what I presented as I did pictures instead of text for the new features.

For clearest understanding, you probably want to download the ppt and actually read the notes attached to each slide.

The Story Of A Migration

I thought I would mine my archives and post a presentation I did a while back regarding a RAC upgrade/migration from Solaris 10.1 to Linux 10.2.

The presentation covers reasons for the migration, the ways we considered doing it, both transportable tablespaces, and data pump. It also shows the issues we encountered during the migration, and some post migration problems.

Comparing ASM with ZFS

I’ll be presenting on the topic of ASM and ZFS at the forthcoming UKOUG UNIX SIG, on the 20th May. I’m really looking forward to the presentation as it will be first presentation I have given in the style of presentation zen. There will be no bullet points in the slides, indeed the slides themselves will be meaningless on their own, though they will be an appropriate accompaniment to the words i’ll be delivering.

I’m currently writing a word document that will be the take-away document for the presentation. So, I’d like to ask anyone popping by the blog, what kind of stuff they would like to see in a presentation on ASM and ZFS? Is there any topics you feel are not addressed all that often, that should go into a talk on this subject?

Below is the general outline of the presentation:

This presentation describes Oracle’s ASM and Sun’s ZFS file systems.  I will tell a little bit of their history and how they actually work.

I will also compare and contrast the file systems, giving an understanding of the benefits of each.

The idea for the presentation came about while I was watching one of the Chief designers of ZFS, Sun’s Bill Moore, give a talk on ZFS. I was of course impressed with the functionality of the file system, though I had heard quite a lot about it prior to this. What I found unexpectedly in the talk that really intrigued me, was that the language Bill was using and some of the concepts expounded on in the presentation would be familiar to a DBA audience.

I was also struck by some of the similarities between ASM and ZFS – they have some unique features in common – what I mean by that, is that there are some advantages a software RAID solution (which both of them are) have over hardware RAID.

I had been running ASM in production for around two years by this time (December 2007) and, I suspect like a lot of DBAs had in some ways treated ASM like a black box. I knew enough to install it and operate it, but knew very little about how it actually worked. In some ways I think Oracle are greatly responsible for this state of affairs, as the stunning lack of documentation available regarding ASM has only bred a lack of understanding.

To be fair, I think Oracle have partly addressed this issue with the 11g documentation set, which now includes a “Storage Administrator” guide. However, they really have only partly addressed this, in that this guide still does not really tell you very many details on how ASM actually works.There is though an ASM book: “Oracle Automatic Storage Management” by Nitin Vengurlekar, Murali Vallath, and Rich Long. This book covers the gap in the explanation of how ASM actually works.

The boundary of responsibility for storage administration has become increasingly blurred within organisations with the adoption of ASM. I think this means DBAs more than ever (though, you could argue it should always have been the case) need to understand storage concepts to be fully in a position to extract the maximum benefit from their storage.

Here I will present some of the ideas behind both ASM and ZFS giving some insight of the benefits of both storage solutions and some of the features they have in common as well as where they differ.

I hope that sounds interesting enough for a presentation, and if you have any tips on what to include I’ll consider every one received.