Search

Top 60 Oracle Blogs

Recent comments

October 2013

Exadata and the passthrough or pushback mode

Exadata gets its performance by letting the storage (the exadata storage server) participate in query processing, which means part of the processing is done as close as possible to where the data is stored. The participation of the storage server in query processing means that a storage grid can massively parallel (depending on the amount of storage servers participating) process a smart scan request.

OTN Nordic Tour 2013

I got up this morning in plenty of time to get to the airport to fly to Sweden to begin the OTN Nordic Tour 2013 tomorrow. I then proceeded to wait and wait and wait for the taxi. Eventually it did arrive, but now the rush hour traffic had started to build up, so time was ticking by and we were standing still for a very long time. I tweeted that I would probably miss my flight and I really believed I would.

After a considerable amount of time, with me trying to ignore the nervous glances of my driver, the traffic opened up, I got to the airport and check-in was empty, as was security. I got through in time to grab a drink on the way to boarding. Phew…

Captain Support and the Windows 8.1 Upgrades

Being the adventurous type of guy he is, Captain Support decided to launch into Windows 8.1 upgrades on his Mom’s and sister-in-law’s laptops. They were identical machines, both running Windows 8 and configured the same. One was local and the other connected to over LogMeIn…

The first thing he noticed about the upgrade is the size of it, approximately 3G. The download and initial install can be done while you’re still using the machine, then comes the inevitable reboot where the real work is done…

The second standout point was the update forced him to him to switch from a local user to a Microsoft Live login. Both Captain Support’s Mom and sister-in-law both use Hotmail/Outlook.com, so this did not present an immediate issue, but it was annoying. Perhaps there is a way to avoid this, but it was not immediately appareent to Captain Support… You can still create local users after the update of course…

Three Things To Do Before Starting Hadoop Project

I spent the last 6 month helping customers design, implement and deploy successful Hadoop systems. Over time, you start seeing patterns. Certain things that if the customer gets right before the project event starts increase the probability that the project will finish successfully and on-time.

Lets assume you already took the most important step – you have an actual use-case or a problem to solve, and you think  Hadoop could be the right technology to use in this case. What now?

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

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.