Author: user

(Otherwise known as #E4) Another late post, but a few weeks ago I had the pleasure of attending and speaking at Enkitec’s dedicated Exadata conference, E4. The stand-out impressions that I’ve been babbling away to people about since getting home were :- 1) The uniformly good quality of the presentations I was able to attend.… Continue reading Enkitec Extreme Exadata Expo

Some features in this post require a Diagnostics Pack license. Just a small tip that could make things a little easier for you one day when you are trying to work out the underlying cause of a SQL execution plan change that leads to degraded performance, after the problem has occurred. There are plenty of… Continue reading OTHER_XML

In a recent blog I described how a mis-timed optimiser statistics collection job led to a bad execution plan for one of the SQL statements in a regular batch job It’s no coincidence that we were already in the process of implementing a change to our stats collection period to retain a short history of… Continue reading Saving Optimiser Stats – 9i

The UKOUG Council elections are in progress and I think User Groups are a critical part of the community. Peter Robson is both a friend and the type of person I admire and want to represent me within the UKOUG but, sadly, the grumpy old sod is possibly the least Web 2.0 chap I know… Continue reading Vote Peter Robson!

Oh, well … having decided that I was going to skip the Symposium this year, everything changed. My friend Randolf Geist had to cancel his attendance so when he saw my previous post he asked if I’d be prepared to step in with a couple of presentations so that he wouldn’t feel quite so bad… Continue reading Hotsos Symposium 2012

Well it wasn’t the post I planned to return to technical matters with. Lots of readers here have asked me when I’m going to get round to writing about 11g Incremental Statistics as part of the stats series. Although Incrementals are on my To Do list, I wanted to finish off the stats copying posts… Continue reading Randolf Geist on 11g Incremental Statistics

At this time of year, I’m usually panicking about my Hotsos presentation/paper and up to my eyeballs in test scripts. I enjoy it and the absence feels a little strange, but I decided to do something different this year. Although it’s the 10th Symposium and I’m sure it will be as educational and fun as… Continue reading Upcoming Conferences

My final UKOUG 2011 post is about another of my favourite presentations –  “ASH Outliers: Detecting Unusual Events in Active Session History” by John Beresniewicz. (JB for short, but Marco Gralike made a fairly good stab at pronouncing his surname correctly during the introduction.) I’d been looking forward to this presentation because I’d already been… Continue reading UKOUG 2011 – Ash Outliers

I noticed last week that the keynote presentation I discussed in a previous post is available on YouTube, in 5 parts …. Part 0Part 1Part 2Part 3Part 4 It was a strange experience watching it again because, although I recognise it as precisely the same presentation, it didn’t have as much impact on YouTube. Perhaps… Continue reading UKOUG 2011 – Cary Millsap’s Keynote Videos

There were a couple of new and related features at this years conference – the Unconference and OAK Talks. The idea of an Unconference will be familiar to those who have attended Openworld – an unscheduled part of the conference that anyone can sign up for to present during a one hour slot. First come,… Continue reading UKOUG 2011 – OAK Talks and Unconference