Top 60 Oracle Blogs

Recent comments

September 2012


My tasks for today

  1. Make sure everyone knows about the Unconference – you’ve got Monday and Tuesday to sign up for a time-slot of 20 or 40 minutes. The event itself is on Wednesday, on the left-hand wing of the balcony in the Exhibition hall. Seating for 30, with a projector, A0 flipchart, and loudspeaker system available. The sign-up sheet / Agenda is up against the wall in the registration area, to the far left – just past the hideous pink pillar. I’ll keep an update of speakers and topics on the blog whenever I can, and you can always tweet your own entry on the #ukoug2012 tag.
  2. Spend some time on the UKOUG Council stand (just to the right of the right-hand door of the Exhition hall) – I’ve signed up for the time-slot that overlaps the exhibition reception drinks (18:30 – 19:30) but I’ll be there by about 18:00

Presentations etc.

Undo Quiz – Bringing the Right Tools for the Job

September 17, 2012 Sometimes humor is a good recipe for undo.  A mid-50s man was driving down the road, riding a purple mule, when he saw a house with a new window.  Uninvited, the man decided to take a closer look using an obvious tool of choice, a tire iron (YPDNTI).  Elapsed time, roughly 60 seconds.  [...]

Private Redo

Following a question on the Oracle Core Addenda pages, here’s a little script to tell you about the sizes of the public and private redo threads currently active in the instance. It’s a minor variation of a script I published in Appendix D (Dumping and Debugging), page 237 to show the addresses of current activity in the various log buffers:

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.