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.
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...)
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...)
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.
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…
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...)
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:
- Being provided by a 3rd party’s hardware via the internet, ie in The Cloud.
- Having your own (more...)
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 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...)
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...)
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...)