Top 60 Oracle Blogs

Recent comments

September 2012

Cloud Control 12cR2 : Is it really release 2?

Oracle Cloud Control 12cR2 is installed and merrily monitoring one of the test 11gR2 databases running on HP-UX. I’ll probably leave it like that until I come back from Oracle OpenWorld. I don’t want to change the entire administration and monitoring infrastructure just as I leave for a couple of weeks.

As I’m re-familiarizing myself with the 12c way of doing things, I’ve been wondering if this really is a full “Release 2″ product, or just 12cR1 with Bundle Patch 2. Not surprisingly, one of my readers asked the same question, pointing out the version does not look consistent with a “Release 2″ product, which would typically be


I’m working on creating two new courses – one of them about Oracle structures (tables, indexes etc.) the other about Oracle mechanisms (undo, redo etc.). The aim of the courses is to help people do the right thing, avoid the wrong thing, and recognise the difference; the latter, as you might guess, is based loosely on my last book. The courses will probably be ready some time around March next year.

One of the problems of creating the content for courses like this is getting the balance between what people really need to know,  what they already know, and what they would really like to know (or know better); so I thought I’d throw the idea open to the public and ask the question: what would you like to learn (more) about if you came on one of these courses.

DOAG 2012

This year again I'm going to present at the DOAG 2012 conference in November. Since it is a popular topic I decided to talk about "Cost-Based Optimizer Basics" there, too. According to the official schedule the presentation will take place on Thursday, the 22nd of November, "Raum 1" at 13:00.

Like last year, I'll also try to do some Unconference sessions in addition - if it is going to take place, which I don't know yet.

I'll post some updates as soon as I know more details.

refresh “fast” of materialized views optimized by Oracle as “complete”

In my current "big" project, I am building a network of nested materialized views to transform rows of one schema into rows of another (very different) schema. The former is used by the old (but still live) version of an application of ours, the latter by the new version; our idea is to incrementally (aka "fast") refresh the network daily in order to have the new schema ready when the new version goes live. We need this nework because we have only a few hours of allowed downtime, and the transformations are very complex: the MV network is going to be composed of at least 200+ MVs, each containing tens of millions of rows.

OOW is 13 days away ...

... well it is for me, anyway.

I know this isn't a universal feeling, but I always look forward to going over to San Francisco for Openworld. There are so many people I'll see that I don't see often enough, lots of cool presentations (if you know where to look) and I expect this year to be a year full of announcements in the areas I care about (and probably in others, too!). I'm gutted that I'll miss the ACE Director briefing because I think I'd be particularly interested this year, but the reality is that it's difficult getting any days away from my current project, never mind a week and a half.

OOW 2012 – Teaser OakTable World

Past Closed World Events, 2009/2010 – Collage OakTable World 2012 – Teaser Past Closed World Events, 2009/2010 – Snapbook

Enterprise Manager Cloud Control 12c Release 2 Installation…

I did an EM Cloud Control 12cR2 installation at work yesterday. The database repository was on HP-UX and the middle tier was installed on RHEL 5.8. The installation was pretty much the same as the 12cR1 version. Over the next few days I’ll be testing out some of the features to decide if we can move across to it permanently.

Today I did two run throughs of single server installations on Oracle Linux 5.8 and 6.3. There are a couple of minor differences, but nothing to worry about. You can see what I did here:

The installations are a little small, so they are not too fast, but it’s good enough to test things out.



UltraEdit 3.2 on Mac and Linux…

I’m now rockin’ UltraEdit 3.2 on Mac and Linux…

This is the version that is meant to bring the Mac/Linux version in line with the Windows version as far as functionality is concerned. I’m not sure that is the case, but it’s getting ever closer. It certainly does everything I need it to do now. :)



VirtualBox 4.2 Released

Hot on the heels of the 4.1.22 release comes Virtual Box 4.2. The downloads and changelog are in the usual places.

It’s a major release with a bunch of interesting new features, so I’ve got an interesting few days ahead while I get to grips with it. You can get an idea about what’s in it here.

Happy upgrading!



OOW 2012 – Oracle XML DB Hands-On Lab (HOL10055)

I posted, as (my) tradition dictates, the Oracle agenda overview of XMLDB sessions during Oracle Open World 2012. I already signed up for the HOL10055 session but yesterday I also got a quick peek of it’s contents this year. And yes, I can promise you, it is a must go, if you are dealing with