Top 60 Oracle Blogs

Recent comments

September 2013

Been away too long

Sorry, it’s been a while since I posted to this blog. Thanks for coming back!

A lot has happened in the last year including new versions of Oracle’s database, ADF, JDeveloper, and SQL Developer. I now have many new features to explore and will share interesting tidbits as I discover them.

I was pleasantly surprised at Kscope 13 in New Orleans when Vikki Lira from Oracle Technology Network informed me that I had been accepted as an Ace Director; many thanks to all who were involved. Once Tim Gorman and Tim Tow taught me the “secret handshake” I was ready to go.

OakTable World 2013

Be aware and act accordingly 8-), that, if you need some brain food, that there is a chance to might want to register for the OakTable World mini conference during Oracle OpenWorld. Agenda and Registration can be done via the following link: OakTable World

UltraEdit 20 Released

If you are an UltraEdit junkie, like me, you can now get your hands on version 20 for Windows. The most noticeable new feature is the ability to skin the editor. Post-installation it shows up with a Sublime style skin, which I immediately reset to classic. :)

You can see the list of changes here.



Warning: Problems with 9.2 clients connecting to databases patched to…

I mentioned this a couple of days ago on Twitter, but I’ve only just go round to posting here…

I recently had to back out some patches because the patch seems to cause problems with Oracle 9.2 client connections where worked fine. I’m not sure how widespread the problem is. All I can tell you is we had two separate occasions (services) where this happened, so we’ve put a halt on patching to until we can identify and upgrade the old clients.

Why are there 9.2 clients lurking around? In some cases it’s due to certification of legacy apps. In other cases it’s because the service owner has been working on a, “if it ain’t broke, don’t fix it”, basis. I guess now it’s broke, we gotta fix it. :)

If you have legacy client installations lurking around, you might want to tread carefully when testing this patch.

Good luck!

Last Successful Login Time in SQL*Plus in Oracle 12c

If you have been working with Oracle 12c, you may have missed a little something that appeared without mush fanfare but has some powerful implications. Let's see it with a small example--connecting with SQL*Plus.

C:\> sqlplus arup/arup

SQL*Plus: Release Production on Mon Aug 19 14:17:45 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Last Successful login time: Mon Aug 19 2013 14:13:33 -04:00

Scanned Copy of Oracle Magazine Article on Oracle 12c Multitenant

My article on Oracle Database 12c Multitenant feature (aka Pluggable Database) has been finally published, after being in the cold storage for about 6 months. You can read it on Oracle Magazine online, which is optimized for a web-presentation.

Here is a scanned copy of the article from the actual magazine. It may be easier to read. Hope you like it.

Lies, Damned Lies, and I/O Statistics



by Matt Hayward

Given a description of gas dynamics and the atmosphere, you would be hard to pressed forecast tornadoes. The term emergence denotes the phenomena of surprising behaviors arising in complex systems.  Modern storage systems are complex, and full of emergent behavior that make forecasting application I/O performance fiendishly difficult.

My stuff at OpenWorld


Analytic Functions [UGF7455]

Analytics have been with us since Oracle8i Database Release 2 (8.1.6), but they are still dramatically underused by application developers. This session looks at the syntax and usage of analytic functions and how they can supercharge your SQL skill set.

SQL Tuning 101 [CON7457]

It’s the age-old problem: the SQL statement that needs to run in 5 seconds unfortunately runs in 10 seconds or 10 minutes, or 10 hours. A SQL statement is e-mailed to you with the simple subject line "Make it faster!". This presentation starts from this point in the process and looks at what you can do to tackle this common issue.

Optimizer Statistics: A Fresh Approach [CON7442]


Pitch Black was an awesome film. It kind of came out of nowhere and delivered a Terminator meets Alien vibe. The sequel, Chronicles of Riddick, was a completely different style of film. I liked it, but I it wasn’t what I expected. Riddick is the third film in the franchise and it tries to revert to the Pitch Black formula.

Oracle OpenWorld (OOW) 2013 : What am I involved in during the conference?

Oracle OpenWord (OOW) 2013 is just around the corner, so things are starting to heat up… My flights and hotel are booked, so I’ve just got to get myself to the airport at 02:00 next Saturday and I’m laughing, or snoring…

I thought I would just take time out to say a few things about my plans for the conference and make a few apologies in advance.

ACED Briefing

Unfortunately I’m not going to make it to the ACED briefing this year. It will be the first one I’ve missed since I joined the program. There seems to be a bit of confusion about why I’m not going to be there. I’m not getting married. I’m not going to a wedding. My colleague just got married and is on honeymoon, so I’m not allowed to take any time off the week before the conference. It’s a pity, bit this stuff happens. It will definitely not happen next year though!!!