Who's online

There are currently 0 users and 25 guests online.

Recent comments



NYC, NYOUG and Delphix on March 12 & 13



photo by Thomas Hawk

Interested in talking face to face about Delphix in NYC?  Drop me a line. I’ll be in NYC on March 12th and 13th and look forward to meeting folks who are excited to learn more about Delphix.


I’m excited about the ease of creating rich user applications  that are web enabled  given the state of technology now. JavaScript and JQuery have gone from being disdained as “not a very serious” language to moving towards the limelight of front and center.

Here is a small example.

Download the following file:  W-ASH (web enabled ASH, file is wash.tar.gz )

Source is also on github at

Go to your apache web server root, in my case on redhat Linux is

Oracle Developer Day Perth

Well…it was a great day with over 100 people attending.

I had the standard fail of trying to show people 200 things that I think are important, in a time allowing only for 50 things, but better to be overfed than starving :-)

Links to the slides are below.  Thanks everyone for coming – hope you had a great day.

Lineage of the 100-400 slide PPT


5727330912_ca5a5a7760graphic by Frits Ahlefeldt-Laurvig

There is the  Mandel approach to power points in presentations where one is suppose to spend 3 minutes per slide, thus a 60 minute presentation is 20 slides or less.

How about going the other way, showing 3 or more slides per minute?

Full free day of performance class at Oracle Corp

This Thursday, Feb 20, I will be giving a full day of free Oracle performance classes.  Remember the serve the best lunch ever at the Oracle conference center . It’s top class!

Register here

Here is the write-up from NoCOUG on the day: Upgrade

A warning on Oracle-L from Chris Dunscombe: If you’ve got a large stats history – with lots of histogram data – then the upgrade could take an unexpectedly long time. Presumably the same is true if you upgrade from (or earlier) to 12c.


Oracle 12c Edition-Based Redefinition (EBR)

Oracle 12c has many great features for DBAs and Developers; I’ll be talking about more features 12c in future articles (watch this space).

Edition-Based Redefinition made its debut in Oracle 11g and provides an ability to significantly reduce downtime due to changes in PL/SQL and/or SQL. Oracle 12c removes some limitations present in 11gR2 implementation of EBR:

  • Materialized Views may use editioned resources
  • Virtual Columns may be used with editioned functions

Materialized Views are not-editionable; but, Oracle 12c allows them to depend upon editioned objects with a new clause and new syntax for ENABLE QUERY REWRITE. The EVALUATE USING clause indicates that a referenced object is editioned (editioned objects are invisible otherwise). ENABLE QUERY REWRITE may be limited to selected editions. The new Materialized View CREATE/ALTER syntax looks something like this:


My provisional agenda for Training Days 2014

3:15 I present “Selectivity and how Oracle calculates it”

8:30 – 9:30 (Difficult choice) Iordan Iotzov – How sure is the optimizer about its cardinality estimates
11:15 – 12:15 (Difficult choice) Andy Colvin – Common Exadata mistakes
13:15 – 14:15 Jeff Smith – Oracle Careers panel discussion
14:30 – 15:30 I present “The revolution in histograms”.
16:00 – 17:00 Terry Sutton – “Now what’s up with dbms_stats”

8:30 – 9:30 Alex Fatkulin – Why you may not need offloading
9:45 – 10:45 Jeff Jacobs – SQL Performance anti-patterns
11:15 – 12:15 Alex Gorbachev – Hadoop for Oracle Database Professional
13:30 – 14:30 Bjoern Rost – The ins and outs of Flashback Data Archives

Then it’s off to the airport before the show is over to get my flight home.

Delphix success and Paternity Leave


photo by Steve Jurvetson

I’m off on for a couple weeks for paternity leave! Actually started on Saturday night a week ago with the beautiful, stressful, exciting, fast birth of our second son. What a gift. :)