Who's online

There are currently 0 users and 32 guests online.

Recent comments



Virtual Columns

This is just a temporary note to let people know I’ve added an update to my Virtual Stats article, highlighting a possible performance threat when you gather stats.

I’ll be deleting this note in a couple of days, so I’ve disabled comments and pingbacks



Database as a Service

Concept of Hand with Electronic Fingerprints

by Chris Fuller and Kyle Hailey

To improve infrastructure and DBMS software utilization, and to drive greater IT operational productivity, companies are implementing internal DaaS capabilities to address their database needs.

Screen Shot 2014-01-15 at 11.17.58 AM


Monitoring Application TCP traffic on Mac


photo by Stuart Williams

My internet provider said my service was degraded due to the large amount of data uploading from my computer. As far as I knew, my computer wasn’t uploading anything but I didn’t know how to prove it.

I decided to try and write a DTrace program to look at it. (I also installed “Little Snitch” which seems pretty cool).

Importance of Feedback


photo by  Idaho National Laboratory

The human brain works so well because it calculates outcomes as it takes actions feeding back the current results compared to the expected results  which allows immediate corrections if the two are not aligning.

automate or die – the revolution will be automated


photo by David Blackwell.

The worst enemy of companies today is thinking that they have the best processes that exist, that their IT organizations are using the latest and greatest technology and nothing better exists in the field. This mentality will be the undermining of many companies.

Continuous Integration for Database Development

Below is a good presentation from Vladimir Bakhov that Dominic Delmolino pointed me to.
( Dominic just did a good presentation with Redgate on CI and TDD available at )

Screen Shot 2013-12-26 at 10.48.45 AM




DataBase CI ENG

Christo Kutrovsky on Oracle, memory & Linux at Oaktable World 2013

Screen Shot 2013-12-23 at 3.46.31 PM

Christo Kutrovsky, from Pythian, gives an awesome talk at Oaktable World 2013 (see )

Dear Santa



Dear Santa,

It’s no secret that there are some tasks that overwhelm existing database architectures, making projects consistently come in over budget and overdue.  This holiday season, on behalf of Database Administrators everywhere, we’d like to ask Santa for:

  1. An end to the constant struggle for more and more disk space for databases and copies

  2. An army of smart elves to run and test backups

  3. Less dependence on physical/virtual administration and storage teams to create working environments for development and QA

The challenge of optimization

With every release of Oracle, more and more power comes to the optimizer.  Many of these are new features (such as adaptive cursor sharing, adaptive optimization, dynamic sampling, etc)…but also within the "core" of the optimizer, there are continuing efforts to transform and interrogate SQL’s to try derive a ‘smarter’ query and hence hopefully a smarter plan.

Its always a balancing act…how much can you re-jig a query without running the risk of actually changing what the query does…

Here’s an example of where that balance is slightly wrong in 12c