Top 60 Oracle Blogs

Recent comments

October 2013

Quiz Night

The following output is the result of two immediately consecutive SQL statements (with “set echo on”), and nothing else happening to the database.

Cloudera Certified Developer for Hadoop (CCDH)

Happy Hadoop

Taking the Cloudera Developer Training for Apache Hadoop had many rewards — one of which was a free voucher to take the CCD-410 Exam (normally $295) which you must pass to get CCDH certified. I’m not sure if that’s a Cloudera University or Global Knowledge thing, but either way it was definitely a bonus.

Virtual date partitions

I posted this question on twitter earlier on today (It was a thought that crossed my mind during a (terrible) presentation on partitioning that I had to sit through a few weeks ago – it’s always possible to be prompted to think of some interesting questions no matter how bad the presentation is, though):

Quiz: if you create a virtual column as trunc(date_col,’W') and partition on it – will a query on date_col result in partition elimination?

The answer is yes – on the version of Oracle that I happened to have to hand (12c) the next time I had a few minutes spare. Here’s a quick and dirty demo – with data adjusted to the publication date, so you may need to adjust the code to your current date.

Hash Clusters – 3

This note is a quick summary of an oddity that came to light after a twitter conversation with Christian Antognini yesterday. First a little test script to get things going:

Oracle VirtualBox 4.3 Released

Oracle VirtualBox 4.3 has been released. The downloads and changelog are in the usual places.

There is a nice write-up about the new features here.

So do I upgrade just before the Nordic Tour, or be boring and play safe until after I get back? :)



Databases for every developer like source code?

Three part post


The simple truth is that databases can’t be given to every developer like source code.

Abstracts, Reviews and Conferences, Oh My!

So yes, I’ve been involved in a number of conferences and in a number of different roles.  I started out presenting, then volunteering  at conferences,  reviewing abstracts, then as a track lead and now as a conference director for RMOUG.  This year I also am the database track lead for ODTUG’s KSCOPE for a second year in a row.

EM administrator jobs

Interesting that we’re starting to see this sort of thing (names removed): Job Title: Senior Oracle Enterprise Cloud Administrator General Information Job Type: Information Technology Base Pay: N/A Req’d Education: 4 Year Degree Employee Type: Full-Time Req’d Experience: 5 to greater than 15 years Req’d Travel: Not Specified Manages Others: False Relocation Covered: False POSITION […]