Search

Top 60 Oracle Blogs

Recent comments

Home » Monthly archive

October 2013

A good day…

Submitted by connor_mc_d on Sun, 2013-10-20 09:58

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

Submitted by Jonathan Lewis on Fri, 2013-10-18 17:08

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 12.1.0.1. 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

Submitted by pete on Fri, 2013-10-18 12:37

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

Submitted by dbakevlar on Thu, 2013-10-17 23:43

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

Submitted by Jonathan Lewis on Thu, 2013-10-17 21:58

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)

Submitted by oraclealchemist on Thu, 2013-10-17 20:15

Happy Hadoop

[This entry is part 5 of 5 in the series Cloudera Hadoop Training] 

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

Submitted by Jonathan Lewis on Thu, 2013-10-17 18:40

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

Submitted by Jonathan Lewis on Wed, 2013-10-16 12:03

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:

Merging and Branching a Database

Submitted by khailey on Wed, 2013-10-16 06:30

Three part post

14-01-21-218_950x510

Oracle VirtualBox 4.3 Released

Submitted by oraclebase on Tue, 2013-10-15 17:14

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

Cheers

Tim…