Top 60 Oracle Blogs

Recent comments

October 2013

A good day…

I work for a company that provides betting to consumers in Australia…

In Australia, the three biggest days for betting are typically:

  • Melbourne Cup (horse race)
  • Caulfield Cup (horse race)
  • AFL grand final (sports)

Yesterday was the Caulfield Cup and we breezed through it…always a nice result.  Because if we dont we lose lots of money…fast.

But the reason for the blog post is not to gloat (well…not entirely :-)).  Its about an important thing about apps under Oracle – here’s my contention:

All that matters is your app.

End of story.

People talk about servers, CPU, flash, disk, bandwidth, memory speed, etc etc etc etc….but all those count for nought if your app is garbage.

To be honest, two years before we deployed our app into production…it was exactly that: garbage.

Deferrable RI

Here’s a lovely little example that just came up on the OTN database forum of how things break when features collide. It’s a bug (I haven’t looked for the number) that seems to be fixed in All it takes is a deferrable foreign key and an outer join. I’ve changed the table and column names from the original, and limited the deferability to just the foreign key:

PFCLScan Version 1.3 Released

We released version 1.3 of PFCLScan our enterprise database security scanner for Oracle a week ago. I have just posted a blog entry on the PFCLScan product site blog that describes some of the highlights of the over 220 new....[Read More]

Posted by Pete On 18/10/13 At 02:36 PM

EMCLI Rel 3, Post 1

So as the book gets under way on the Enterprise Manager Command Line Interface, (EMCLI) I’m starting to move away from the introduction statements that I commonly was required to repeat to folks, (“it’s the return to the golden age of the DBA 1.0- command line, baby!” :)) and now are onto what has changed in release 3.

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? :)