Category Archives: Oracle

Develop against the versions in the Yum repositories!

I saw a tweet by Simon Haslam at the weekend that read,
“I’m v surprised to read that @Atlassian Stash needs newer git than in the latest RHEL/OL6 repos!”
I had a similar experience at the weekend too, but this time with Oracle REST …

Fedora 21 : Oracle 11g and 12c Installations

Fedora 21 has arrived and it’s now delivered in three focussed flavours (Workstation, Server and Cloud). This of course resulted in the usual articles from me.

Fedora 21 (F21) Installation
Oracle Database 11g Release 2 (11.2) Installation On Fed…

Parse Time

Here’s a little query I wrote some time ago to see where my time went while running a query. It’s nothing sophisticated, just one of those simple things you can do with v$active_session_history (or dba_hist_active_sess_history, if you don&#…

Riga Dev Day 2015

Over the weekend I booked my flights and hotel for the Riga Dev Day on January 22nd.
It’s my first time in Latvia, so I look forward to seeing everyone out there!
Cheers
Tim..
Riga Dev Day 2015 was first posted on December 9, 2014 at 2:09 pm.©20…

Oracle ACE Program : Thanks Folks!

As you will know from my previous post, I picked up the “UK Speaker Award” at UKOUG Tech 14. I’ve already done a bunch of thank you messages, but I’d just like to take a minute and thank the Oracle ACE Program for the part they …

UKOUG Tech 14 : Monday

The day started with a taxi ride into New Street station to get the 06:01 train to Liverpool Lime Street. I was a little dissapointed that the train was a sprint train, so there were no tables and no power sockets. When the ticket guy came through I as…

Cardinality Change

Here’s an entertaining little change across versions of Oracle, brought to my attention by Tony Hasler during UKOUG Tech 14. It’s a join cardinality estimate, so here are a couple of tables to demonstrate the issue – the only columns…

Join Us For a Networking Event at UKOUG

Ask not what you can do for your data. Ask what your data can do for you!
Join us for an informal networking event alongside Rittman Mead on Monday December 8th during UKOUG. We will be discussing how to leverage data to drive your organization’s su…

RELY DISABLE

Learning, relearning or unforgetting…
What value is there in a DISABLEd constraint?
This was a question on the OTN forums this week and a) my first reply was wrong and b) I couldn’t find a clear demonstration elsewhere.
The key is RELY.
The…

Closure

It’s been a long time since I said anything interesting about transitive closure in Oracle, the mechanism by which Oracle can infer that if a = b and b = c then a = c but only (in Oracle’s case) if one of a, b, or c is a literal constant r…