Category Archives: Oracle

Riga Dev Day and Oracle Midlands Event #7

There are a couple of things on the radar for the coming week and unfortunately for me they are both on the same day.
In Birmingham, UK it is Oracle Midlands Event #7 (OM7) on Thursday 22nd of January. This will be the first Oracle Midlands event I&#8…

Spatial space

One thing you (ought to) learn very early on in an Oracle career is that there are always cases you haven’t previously considered. It’s a feature that is frequently the downfall of “I found it on the internet” SQL.  Here&#8217…

Execution Plans

This is the index to a series of articles I’ve been writing for redgate, published on their AllThingsOracle site, about generating and interpreting execution plans.
When I started I didn’t really know how many parts it was going to end u…

Bind Effects

A couple of days ago I highlighted an optimizer anomaly caused by the presence of an index with a descending column. This was a minor (unrelated) detail that appeared in a problem on OTN where the optimizer was using an index FULL scan when someone w…

Using Database In-Memory Column Store with Complex Datatypes

From those who are interested, hereby my slide deck I used during UKOUG Tech14, regarding…

FBI Bug reprise

I’ve just had cause to resurrect a blog note I wrote three years ago. The note says that an anomaly I discovered in 9.2.0.8 wasfixed in 10.2.0.3 – and this is true for the simple example in the posting; but a recent question on the OTN d…

Robert G. Freeman on Oracle 2015-01-09 23:01:11

I was working on something today and started to muse on names. By names, I mean things like host names, service names, database names, PDB names, listener names and so on. 
I started to mull over the question of the use of descriptive vs. non-d…

Cloud Control : 12.1.0.7 Plugin Patch

I applied some of the 12.1.0.7 plugin patches to our Cloud Control installation today. We already have Cloud Control 12.1.0.4 installed, so this was just a case of updating the plugins.
Here’s a quick overview of what I did.

Backup up everythin…

count(*) – again !

Because you can never have enough of a good thing.
Here’s a thought – The optimizer doesn’t treat all constants equally.  No explanations, just read the code – execution plans at the end:

SQL> drop table t1 purge;
SQL&…

Robert G. Freeman on Oracle 2015-01-07 21:56:12

Note: Something happened to this original copy of this post. I’m not sure what it was, but somehow it was like a draft copy ended up being posted and it lost almost half it’s content. I have re-created the post. So, for those of you who saw the earlier…