A Different Type of Keynote & Jonathan Lewis Panel Session at UKOUG Tech15

Technical people tend not to enjoy Keynotes at conferences. We are allergic to content-light “there has never been a better time to invest in our products” fluffy, frou-frou, big picture talks. We want how-it-works meat on the bones of what is served up to us.

OK, it's a very poor photo but the best I have of Dom presenting. Sorry Dom.

OK, it’s a very poor photo but the best I have of Dom presenting. Sorry Dom.

Well, at the UKOUG Tech15 conference this year (Birmingham ICC 7th-9th December) we have (more...)

Pragma UDF – Some Current Limitations

There are currently some limitations to when pragma UDF will speed up your calls to PL/SQL functions.

In my post introducing the new pragma UDF feature of Oracle 12c I explained how it can be used to reduce the impact of context switching when you call a PL/SQL function from SQL.

In my example I showed how running a SQL-only SELECT statement that formatted a name for display over 100,000 records took 0.03 seconds (more...)

Friday Philosophy – We Could Be Heroes! {just for one day}.

At Open World I overheard a snippet of conversation which went something like this:

Bob – “How’s it going? Did the last talk go down well?”
Bill – “Sure, it was on time, the audience seemed to like it.”
Bob – “Will you be here next year?”
Bill – “Errmm….” pause…*sigh*… “I don’t know…. I’ll see how I feel.”
Bob – “Oh? In what way?”
Bill – “It just (more...)

Pragma UDF – Speeding Up your PL/SQL Functions Called From SQL

A new feature for PL/SQL was introduced in V12, pragma UDF. UDF stands for User Defined Functions. It can speed up any SQL you have that uses PL/SQL functions you created yourself.

We can create our own functions in PL/SQL and they can be called from both PL/SQL and SQL. This has been possible since V7.3 and is used extensively by some sites to extend the capabilities of the database and encapsulate business logic.


OOW Report – No List of Talks, No Cloud, Just Thoughts on Community

As I type I am in my hotel, sipping a final beer (it was a gift that has been to a few talks with me in my backpack) and looking back at Oracle Open World 2015. I must confess I am a little drunk so we will see if this post lasts…

OOW15 beers

I am on record as saying I don’t like Open World. I came to previous events in 2003 and 2004 I think (yes, (more...)

The “as a Service” paradigm.

For the last few days I have been at Oracle Open World 2015 (OOW15) learning about the future plans and directions for Oracle. I’ve come to a striking realisation, which I will reveal at the end.

The message being pressed forward very hard is that of compute services being provided “As A Service”. This now takes three flavours:

  1. Being provided by a 3rd party’s hardware via the internet, ie in The Cloud.
  2. Having your own (more...)

Friday Philosophy – The Small Issue of Planes, Trains and…Coaches.

Today I get on a plane. It is a long flight, 10+ hours, and throughout all of it, some people will hate me. I even expect some Hard Stares. Why? Because I’ll be sitting in a seat with a large space in front of it – and my legs dangling off the front of the seat. Those over 6 foot will be fuming I have that extra leg room. See me sitting there. See me (more...)

Where do my trace files go? V$DIAG_INFO

Where do oracle trace files go? I don’t know why this piece of info will not stick in my head, I seem to have to look it up 3 or 4 times a year.

If only I had an easy way to find out. There is a very easy way to find out – and that piece of info won’t stay in my head either. So this really is a blog post just for stupid, (more...)

Friday Philosophy – 3 months, 3 conferences

Flights are booked, hotels reserved, plans made. Don’t ask about talks prepared, just don’t :-)

This is not the usual list of “I’m going to this talk and I’m seeing that speaker” blog that people write before an event – well it is a little – it’s more about the different flavors of conference we have available to us.

I have an Oracle conference a month until the end of the year and I’m really (more...)

Friday Philosophy – Be Moral or Be Sacked?

How far will you bend your moral stance to keep your job?

This post was prompted by a Twitter discussion over the recent VW Emissions scandal development where software engineers are being blamed. Let’s just skip over the rather trite and utterly unbelievable proposition that a couple of rogue software engineers did this “for reasons unknown” – and the fuel engineers, mechanical engineers, and direct managers did not realise “hey, our engines are more efficient (more...)