Who's online

There are currently 0 users and 36 guests online.

Recent comments


Twitter : Is it a valuable community contribution?

During a conversation with Zahid Anwar at OOW15, the question was asked, is Twitter content a valuable contribution to the community?

The following is *my opinion* on the matter. Other opinions are valid.

The sort of tweets I see fall into the following basic categories:

APEX 5.0.2 : Let’s get patching!

APEX 5.0.2 was released just before OOW15. Today is my first day back to work, so I’ve started to patch some stuff. We were already on APEX 5.0.1 across the board, so we didn’t need to do any full installations, just patches.

SO far, so good. No problems in any Dev or Test databases. I expect a pretty quick roll-out across the board.




I had a recent conversation at Oracle OpenWorld 2015 about a locking anomaly in a 3-node RAC system which was causing unexpected deadlocks. Coincidentally, this conversation came about shortly after I had been listening to Martin Widlake talking about using the procedure dbms_stats.set_table_prefs() to adjust the way that Oracle calculates the clustering_factor for indexes. The juxtaposition of these two topics made me realise that the advice I had given in “Cost Based Oracle – Fundamentals” 10 years ago was (probably) incomplete, and needed some verification. The sticking point was RAC.

Oracle OpenWorld 2015 : It’s a Wrap

I’m back home from Oracle OpenWorld 2015. My overall feeling for this year was evolution, not revolution. We got newer versions of some products, like APEX, WebLogic, SOA Suite and Oracle Forms, just before the conference. We got previews of new versions of products, like Oracle Database 12cR2 during the conference, which we might get next year.

Of course, there was a heavy emphasis on cloud, but the difference between this year and previous years was some of the product are now generally available (GA), so it’s possible to trial or buy them. In previous years, you could only use some of the cloud products if you were “special”.

Oracle OpenWorld 2015 : The Journey Home

I was awake at 04:30, about 15 minutes before my alarm and wake-up call. That reduced the levels of panic normally associated with such an early start. I dropped off my key-card with the guy on the hotel check-out and got into the waiting car and off I went.

I think this was the first time I’ve ever left San Francisco via the domestic terminal. Getting the bags checked in and doing security was pretty straight forward, so I sat down with about 90 minutes spare before the flight.

The flight to Newark was event free, but the guy on the arrival gate at Newark was a complete dick. As we walked through, he said, “Welcome to Boston”, which I can only assume was meant to be a joke. Yeah. Great joke. Idiot!

Oracle OpenWorld 2015 : Thursday

Thursday is always an odd day at OpenWorld. The exhibition hall and demo grounds are closed, people start to drift off during the morning and some people party too hard the evening before. :)

Oracle OpenWorld 2015 : Wednesday

Wednesday started early. I was invited over to breakfast with the Dbvisit crew, which was a great start to the day. I met Arjen years ago and the Dbvisit team have continued to be good people ever since. It’s always good when I get to meet up with them!

IT Analytics- Global Database Performance

This is one of about 40 blog posts I’ve been eagerly awaiting for permission to post on the Oracle Management Cloud, (OMC)!  There are three main products that will be offered initially through the Oracle Management Cloud

SQL Monitoring in Oracle Database 12c

Here’s my latest OOW presentation – SQL Monitoring in Oracle Database 12c:

[direct link]

You can download all my scripts from



NB! After a 1.5 year break, this year’s only Advanced Oracle Troubleshooting training class (updated with Oracle 12c content) takes place on 16-20 November & 14-18 December 2015, so sign up now if you plan to attend this year!

Oracle OpenWorld 2015 : Tuesday

The day started in the normal way, with a quick blog post about the previous day and a visit to the gym.

The original plan for the day was to hit the demo grounds again. I popped into OakTable World for the quick chat with a few folks and ended up staying for quite while. I watched some of the Ted-style talks, specifically Tim Gorman, Jonathan Lewis and Martin Klier. I then got chatting to some folks outside, before heading back in to see Gwen Shapira do a session on Kafka.