Top 60 Oracle Blogs

Recent comments

August 2013

SQL joins visualized in a surprising way

Saw a good posting on SQL joins today that echoes a classic image of SQL joins:


I loved this graphic when I first saw it. Seeing the graphic made me think “wow, I can actually wrap my mind around these crazy SQL joins.”

But there is more to SQL joins than meets the eye, at least in these pictures. These pictures leave out the effects of projection and amplification. For example, just taking the simplest case of a two table join (an inner join):

Creating a 12c Container Database from scripts

If you are curious how to create a CDB without the help of dbca then the “generate scripts” option is exactly the right approach! I am a great fan of creating databases with the required options only-the default template (General Purpose) is dangerous as it creates a database with options you may not be licensed for and additionally opens security risk.

The best^H^H^Heasiest way to understand how a Container Database (CDB from now on) is created is to let dbca create the scripts. The process is the same as with an interactive installation except that at the very end you do NOT create the database but tick the box to generate the scripts.

The resulting scripts will be created in $ORACLE_BASE/admin/${ORACLE_SID}/scripts. Change directory to this location and you will be surprised about the sheer number of files ending in *.sql

Facebook Schema and Peformance

From the article “Facebook shares some secrets on making MySql scale

“800 million users and handling more than 60 million queries per second” …”4 million row changes per second.”

and that was almost a two years ago. Think what it’s like now!

Ever wonder why Facebook limits your friends to 5000?  Does Facebook want to stop people from using it to promote themselves?

Ever see this message “There are no more posts to show right now” on Facebook?

Notice it says “There are no more posts to show right now.”

Delphix finalist for UKOUG partners of the year


Delphix  is a finalist for UKOUG partners of the year!

See the finalist at UKOUG finalists for partner of the year

Vote here : UKOUG parnter of the year awards 2013

Also on the list are fellow Oaktable related organizations Scalabilities and Enkitec



Kyle Hailey

Enkitec is a finalist for the UKOUG Engineered Systems Partner of the Year Award

Enkitec has made it to the shortlist of UKOUG Partner of the Year Awards, in the Engineered Systems category. So if you like what we have done in the Exadata and Engineered Systems space, please cast your vote! :-)

Note that you need to be an Oracle user – using your company email address in order to vote. (the rules are explained here).


Latency heatmaps in D3 and Highcharts

See Brendan Gregg’s blog on how important and cool heatmaps can be for showing latency information and how average latency hides what is really going on:

Now if we want to create heatmap graphics, how can we do it? Two popular web methods for displaying graphics are Highcharts and D3. Two colleges of mine whipped up some quick examples in both Highcharts and D3 to show latency heatmaps and those two examples are shown below. The data in the charts is random just for the purposes of showing examples of these graphics in actions.

We are proud to be finalists AGAIN for UKOUG Database Partner of the Year!

We are very proud to once again be shortlisted as the UKOUG Database Partner of the Year! We would love to make it two years in a row, so if you think we do a great job we'd love to receive your support. The alphabetical shortlist is available here for all categories. To vote, you simply […]

Looking for past posts?

My previous blog had out grown the limited area of just Oracle. The current blog will cover broader areas of data mobility, agility and visualization.

If there are past posts that you are looking for, please drop me a line and I will prioritize them for posting on this blog.



Death of the Storage Array

When I wrote this article for The Register in October 2010, there was a torrent of naysayers and witch hunters spewing their opinions in the comments section. I don’t have a problem with that, I was only expressing an opinion myself, after all. I don’t actually own a time machine and so any of my … Continue reading "Death of the Storage Array"